Jump to content

Recommended Posts

Posted (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 by Bob Crabb
Posted

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

Posted

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.

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...