MySQL 4.0 to 4.1 Upgrade Testing Mode
Submitted by chris on December 2, 2006 - 17:26.
MySQL Install
Several visible behaviors have changed between MySQL 4.0 and MySQL 4.1 to fix some critical bugs and make MySQL more compatible with standard SQL. These changes may affect your applications.
Some of the 4.1 behaviors can be tested in 4.0 before performing a full upgrade to 4.1. This gives you the 4.1 behavior for the most critical changes. That way you can test the most new behaviors in 4.0 to make sure that your applications work with them. This helps you have a smoother transition when you perform a full upgrade to 4.1 later.
3 Way to run 4.0.12 or above in this 4.1 "simulation" mode:
1) From the command line:
We have added to later MySQL 4.0 releases (from 4.0.12 on) a
--new startup option for mysqld. See
Section 5.2.1, “Command Options”.
2) For a particular client:
You can also enable these behaviors for a given client connection with the
SET @@new=1 command, or turn them off if they are
on with SET @@new=0.
3) In the my.ini file (the one I'm running):
[mysqld-4.0]
new
Putting the --new option in the [mysqld-4.0] option group ensures that you do not accidentally later run the 4.1 version with the --new option.
delicious
digg
reddit
google
technoratiMigrate from MySql Data...
Submitted by chris on February 19, 2008 - 04:19.
Thanks for the tips.
I've create a quick article on migrating data using MySQL Administrator here:
Migrating simple MySQL data (ie English)
Please note that those with no English languages (i.e. accents...etc..) might have to do some "character set" conversion. For some tips on this, see this more complete article: MySQL upgrade
» reply
Migrate from MySql 4.X to MySql 5.X.
I have just migrated from MySql 4.x to 5.x. At a first time I tray to use MySql Migrate Tool. Because of same huge tables MySql Migrate Tool hangs up and cannot complete the task. So I get an idea.
List of DB: PHPBB3 database and 5 my own databases in 3 languages (English, Polish, Danish)
Migration:
1. Start MySql administrator connecting to MySql 4.x
2. Start new backup project and backup databases.
3. Start MySql Query Browser connecting to MySql 5.x
4. In the file menu go to Open Sql Script and browse to your backup, then open backup file you just made.
5. Run the script.
6. After a 2 or 3 minutes you’ve gat all databases in MySql 5.x
Hope this can help somebody.