Migrating simple Mysql data (ie English) from 4.0.x to 4.1.x.

I'm migrating data in plain English so no weird characters (like accents ...). For a more complete article on migration, especially when having issues with Character Sets (for example: Languages with accents ..etc..), see: MySQL Upgrade
(this will happen, more likely, when migrating from MySQL pre 4.1.x. MySQL 4.1 introduced the support for multi-byte character sets like utf8)

1) Start MySQL Administrator on 4.0.x server, go to "Backups".

2) Create a new project: "Export1", select your database.

On the advanced tab, I picked the option  "Lock all tables" (I'm exporting MyISAM tables).

Keep the default options selected: "Add Drop...", "Complete INSERTs", "Comment", "Disable Keys"

Click "Execute Backup Now" button.

Note: Just as a precaution I recommend backing up your target MySQL server databases (ie a quick file copy)

3) Start MySQL Administrator on 4.1.x server, go to "Restore".

Open the file you previously saved.

As a precaution I create the new schema and selected this schema in the "Target Schema" (would hate to overwrite one of my current tables).

At this point you might also want to create the same user as on the older DB and give the appropriate rights to the schema you created.

Kept the defaults: "File Charset: utf8".

Note: You can also go to the "Restore Content" tab and "Analyze Backup File Content" to verify that the backup file is interpreted correctly (i.e. no errors).

Now click the "Start Restore" button.

Done...it all  worked good.

Additional precautions:

a) Immediately update your applications DB settings. Make a small change to that should be easy to verify in your database and verify that the new DB is being updated (You can uses the MySQL QueryBrowser to verity that the change is updated in your new database).

b) Backup (ie. perform a quick file copy) and delete the old database.

c) Verify the application is still running correctly.