mysql contains info that mysql uses for things like user accounts,
permissions and the like
information_schema keeps information about the databases etc inside mysql.
Basically they do not contain user data, however you may wish to copy
across the mysql.users table or at least the elements that aren't in the
new one.
(changing the password for the debian user is not a good idea ;->, its
randomly generated on each machine during setup)
On 19/08/10 08:41, Ben Donohue wrote:
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
