Bob Crabb Posted November 14, 2007 Posted November 14, 2007 (edited) The server hosting one of my sites was upgraded to PHP 5 and mysql 5.0.27 this morning. Checking out the site, I see a new database named "information_schema". Was this something installed and used in the upgrade process? Can I delete this database, or should I open a ticket? EDIT -- I only see this db as an option in the database selection dropdown in phpMyAdmin. It does not show up in the database listing in cpanel. Edited November 14, 2007 by Bob Crabb Quote
dcumpian Posted November 14, 2007 Posted November 14, 2007 This is an internal database that MySQL uses to store information it needs about the databases that it is managing. DO NOT delete this database... Regards, Dan Quote
MikeJ Posted November 14, 2007 Posted November 14, 2007 You can't drop it anyway. information_schema is just a database of read-only views of some metadata in mysql, and only the metadata that corresponds to your account will be visible to you. For the majority of you, you can just ignore it. Quote
Bob Crabb Posted November 14, 2007 Author Posted November 14, 2007 Thanks for the info. I am in phpMyAdmin on that account every day, and it had not appeared until this morning. Not knowing what information schema is, I thought that I would post here before doing anything else. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.