Transfer MySQL Database Offline

Transfer MySQL database offline means, stop MySQL service, copy the database directory and paste it to another location directly. However it will be difference when transferring MyISAM database and InnoDB database:

• MyISAM: simply copy past the database directory (data\databasename) will do since all the data files are inside the directory
• InnoDB: need to copy the whole data directory (data), which all the databases will be copied as well. After you paste the directory to the destination, you need to remove the ib_logfile0 and ib_logfile1 before start the MySQL service