SLUG Mailing List Archives
Re: [SLUG] mysql restore
- To: slug <slug@xxxxxxxxxxx>
- Subject: Re: [SLUG] mysql restore
- From: Rick Phillips <rick@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2010 06:06:40 +1000
- Reply-to: rick@xxxxxxxxxxxxx
> 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.