vicker313 tech blog

September 1, 2009

Transfer MySQL Database Offline

Filed under: MySQL — Tags: , , — vicker313 @ 8:00 am

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


  1. Simple and Sweet Definition

    Thank U….!!!

    Comment by prabhu — June 11, 2010 @ 3:08 pm

  2. Nice Definition.

    Thank U…!!!

    Comment by prabhu — June 11, 2010 @ 3:09 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: