0

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.

cedivad
  • 680
  • 3
  • 13
  • 25

1 Answers1

3

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.

Khaled
  • 35,688
  • 8
  • 69
  • 98