restoring myisam mysql db on a different machine

Posted by RainDoctor on Server Fault See other posts from Server Fault or by RainDoctor
Published on 2010-04-02T06:24:53Z Indexed on 2010/04/02 6:33 UTC
Read the original article Hit count: 523

Filed under:
|

I have copied the web db directory(/var/lib/mysql/data/web/), when mysql is not running. I transferred this directory to another machine, where mysql is running.

web db's stuff is myisam based.

I am thinking about how to restore this on a different server. The strategy I have on my mind is the following.

  1. copy the data directory of web db to the new server.
  2. on new server, 'create database web', which creates a directory in /var/lib/mysql/data
  3. copy all files from the step to the new directory created in 2.
  4. bounce mysql

My question: how to deal with information_schema for this new db?

© Server Fault or respective owner

Related posts about mysql

Related posts about mysql-server