Migrate MySQL 4.1 to MySQL 5.x (XAMPP for Windows)

I recently moved a standalone MySQL 4.1.7 Server across to a brand new XAMPP Server Running MySQL 5.1.41. This post sets out the procedure I used.

Backup the Existing Database (on the Source Server)

  1. Load phpMyAdmin
  2. Select the database you wish to Migrate (make a not of the Collation Type)
  3. Select the “Export” Tab
  4. Check “Save as File” Click "Go”

Create an Empty Database (on the new XAMPP Server)

  1. Load phpMyAdmin
  2. Create an Empty Database (with the same name and collation as above)

Import the Database (on the new XAMPP Server)

  1. Within phpMyAdmin, Select the Empty Database (created above)
  2. Select the Import Tab
  3. Browse / Select the “Export File” created previously and Click "Go”
  4. Await confirmation of Successful Import **.

** Failure to create an Empty Database on the New XAMPP Server causes Error 1046 “No Database Selected” during the Import Operation.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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