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
Advertisements

2 Comments »

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: