Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
Linux / mysql: is it safe to copy mysql db files with cp command from one db to another?

mysqldump will take 5 hours to run. I have no idea of how much it will take to restore the tables; the database is 300GB in size.

Can't i just shutdown mysql and copy the raw data? Please note that i also want to rebuild (destroy and recreate) the innodb log files. I will use the same version of MySQL and InnoDB (xtradb) is my storage engine.

share|improve this question

marked as duplicate by Iain Apr 13 '12 at 6:58

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 3 down vote accepted

Yes, sure. You can shutdown mysql server and copy the data dir to another partition or machine. Then, you can start mysql server after checking the permissions.

You should be fine while you are moving through similar platforms. Otherwise, you may face troubles and then you should revert back to using mysqldump.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.