Web Hosting Talk







View Full Version : Help transfering MySQL database


phponly
06-18-2009, 01:54 AM
I am trying to install a script and I need to add the database, but it does not let me. It gives me errors.
The database file is from "MySQL version 5.0.77-community" and I am trying to import it to "MySQL 3.23.58". Is there anything that I can do to move the database from a new version to an older version? I see that the data file is not compatible with the old version of MySQL.

DATABASE FROM
cPanel Version 11.24.4-RELEASE
cPanel Build 36167
MySQL version 5.0.77-community

TO

Ensim Pro 4.0.2-7
MySQL 3.23.58

Please help.

Thank you!

foobic
06-18-2009, 03:01 AM
On the mysql5 machine you can use "mysqldump --compatible=mysql323" (or there should be a similar option in phpmyadmin).

But a much better idea is not to use 3.23 at all - it's ancient. You may well find that even with the database converted your script doesn't work with it.