restoring myisam mysql db on a different machine
- by RainDoctor
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?
