GoFuckYourself.com - Adult Webmaster Forum - View Single Post - help... moving one MySQL DB to another server

rowan · 09-30-2009, 09:31 PM

If your mysql version is the same and your OS is the same "flavour" (eg not moving from 32 to 64 bit) then you may just be able to copy the entire database directory, which will also preserve your user accounts and permissions. Make sure mysql is NOT running on either server when you do this.

Doing it this way will save time since mysql won't have to reinsert everything and build indexes on the fly. (How many rows you got in that table?)

09-30-2009, 09:31 PM
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	If your mysql version is the same and your OS is the same "flavour" (eg not moving from 32 to 64 bit) then you may just be able to copy the entire database directory, which will also preserve your user accounts and permissions. Make sure mysql is NOT running on either server when you do this. Doing it this way will save time since mysql won't have to reinsert everything and build indexes on the fly. (How many rows you got in that table?)