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
