GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Moving MySQL DBs from one server to another

XXXManager · 10-01-2002, 09:10 PM

Hey HQ.
Its that simple...
1. Shutdown the MySQL server (on both machine). [mysqladmin shutdown]
2. Copy the DB files of the specific Databases/Tables you want to copy to the other server.
3. start the MySQL server again.

Only reservation - Not working on INNODB Tables (for that you will need either to alter the table type or copy it to a duplicate table of type INNODB or do a dump) - but im not sure you are using this.

10-01-2002, 09:10 PM
XXXManager So Fucking Banned Join Date: Mar 2002 Location: Far out in the uncharted backwaters of the unfashionable end of the Western Spiral arm of the Galaxy Posts: 893	Hey HQ. Its that simple... 1. Shutdown the MySQL server (on both machine). [mysqladmin shutdown] 2. Copy the DB files of the specific Databases/Tables you want to copy to the other server. 3. start the MySQL server again. Only reservation - Not working on INNODB Tables (for that you will need either to alter the table type or copy it to a duplicate table of type INNODB or do a dump) - but im not sure you are using this.