I need to move a database from an old disk which is no longer bootable to a new bootable disk. I have been able to mount the old disk. Now I need to move the database from there to a new disk. Can this be done? Where do I start and what do I need to move?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You should be able to create a new database with the same name on the new system, shut down the service, replace the new (empty) files for your database with the old ones and finally start the service again. See http://www.kimvette.net/linux/recover_and_mount_mysql_database_files_after_recovery for more info.
Make sure that you have logged in as