I replaced all except those two and it seemed to work ok.
Not sure that they are needed or connected to the other db's.
I was going to restore them if needed but it looks like they are not.
Thanks for your reply.
On 19/08/2010 12:16 AM, Voytek Eymont wrote:
On Wed, August 18, 2010 4:54 pm, Ben Donohue wrote:
I'm doing a mysql restore to a new server that has a mysql database on
it. As in just installed mysql.
show databases shows two databases "mysql" and "information_schema".
My backups from a previous server has many db's including two called
mysql and information_schema.
Do I have to drop the new server's mysql and information_schema
databases and reload my own or are these not used or needed by mysql or
what are they for?
Any clues appreciated.
Ben,
as a semi literate or perhaps semi illiterate* guess, I'd dump/drop them,
and use the 'mysql' and 'information_schema' from old server.
*I just browsed both db, most contents in there relates to user's databases
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
