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?