By askttt on
My recent sql dump provided me with a sql file that renders 2 databases: Mydatabase & information_schema. Was that a bad export or are there 2 databases?
My recent sql dump provided me with a sql file that renders 2 databases: Mydatabase & information_schema. Was that a bad export or are there 2 databases?
Comments
=-=
if you are exporting from only 1 database, then there is only one database. However you shouldn't have 2 files. Investigate the videocasts section of the handbooks, there is a videocast on upgrading, which will show you how to export your DB properly.
_____________________________________________________________________________________________
give a person a fish and you feed them for a day but ... teach a person to fish and you feed them for a lifetime
2 databases
I exported the database with the only tool godaddy provided. Whether that tool messed up or not....I don't know. The information_schema database contains tables labled "carachter_sets", "collations" "tables" "user_privlidges" etc. Are those tables that are inherent to a main drupal database? could it be from a module?
=-=
information that a module adds to the database would be exported into the same export as drupal core. Go Daddy does not offer phpmyadmin ? This seems a bit odd to me ?
The only suggestion I have at this point, if you don't have access to phpmyadmin, is to import the files you have through GoDaddy tools, into a new DB and see if they import correctly. If they do, then you should be good to go, if they don't then you know you have to avoid using GoDaddy tools and seek out a better method.
_____________________________________________________________________________________________
give a person a fish and you feed them for a day but ... teach a person to fish and you feed them for a lifetime
2 databases
Yes, godaddy does provide phpmyadmin, albiet a watered down version. THAT is what produced the .sql file with 2 databases. Their support desk can't understand what happened.
I've spent the evening re-creating the site and now am looking for a more robust backup tool. Can you recommend one?
=-=
if they allow it, a full blown phpMyadmin
_____________________________________________________________________________________________
give a person a fish and you feed them for a day but ... teach a person to fish and you feed them for a lifetime
2 databases
The database "information_scheme" is a MySQL internal database which contains internal administrative information about the other databases in your MySQL system (META database). So it does not belong to your drupal system. The MySQL handbook is the better source for this.