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
mysql
|mysql-server
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.
- copy the data directory of web db to the new server.
- on new server, 'create database web', which creates a directory in /var/lib/mysql/data
- copy all files from the step to the new directory created in 2.
- bounce mysql
My question: how to deal with information_schema for this new db?
© Server Fault or respective owner