Thanks Rick,
did exactly that and working well now. Thanks for you help.
Ben
On 19/08/2010 6:06 AM, Rick Phillips wrote:
Hi Ben,
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?
I have successfully transferred from old to new servers many times and
have never touched the "new" mysql and information schema so my
suggestion is to leave them. Everything has always just worked.
The best way to transfer data from one server to another is to use
mysqldump on the old server DBs and re-import the data on the new.
Rick
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
