- Tested with mysqld
Ver 5.1.73 for pc-os2-emx on i386 (Source distribution)
and
Ver 5.6.51 for OS2 on i386 (Source distribution)
- The following assumes
5.6 datadir will be /data/mysql56
5.1 datadir is /data/mysql51
innodb_data_home_dir is /data/mysql56-data/innodb
- Use names that match your setup
- Open session with current directory set to 5.6 bin directory
Run binaries from the directory
- Verify my.cnf is 5.6 compatible
Edit as needed to protect/hide 5.1 data
- Create /data/mysql56
- Create /data/mysql56/mysql
- Create /data/mysql56/innodb
- Copy /data/mysql51/mysql to /data/mysql56/mysql
- Run
mysqld --console
The server should start
There will be warnings
- Run
mysql_upgrade
The server may crash
- If the server crashes, run
mysqld --console
to restart the server
There will be warnings
Run
mysql_upgrade
to retry the upgrade
The upgrade should run without errors
if not get help
- Copy the rest of the 5.1 databases to /data/mysql56
- Run
mysql_upgrade --force
to upgrade these databases
The upgrade should run without errors
If not get help
- Run
mysqlcheck --all-databases
to cross-check upgrade results
- Check /data/mysql56/mysql_upgrade_info
It should contain 5.6.51
The logs imply that, at least in my case, only the mysql database needed
unusual modifications. The log output for all the other databases and
tables reported OK with no additional messages or warnings.
back to list