Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to export the schema and data from a MySQL version 4.0.16 DB.

I was asked to migrate a database from MySQL version 4.0.16. The database was installed on a Windows XP machine, and I could not find mysqldump on that machine.

I then putty into a Linux machine that has mysqldump. I ran the command, but got an error:

-bash-4.1$ mysqldump --databases db_2_dump --host='myhost' --port='6012' -u <user> -p >db-export.sql
Enter password:
mysqldump: Error: 'You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILE' when trying to dump tablespaces

I looked up MySQL reference. INFORMATION_SCHEMA is something new to version 5 and above.

This means the mysqldump on the Linux box is incompatible with the production MySQL server which is on v4.0.16.

I tried to download MySQL 4.0 server and install it on a Windows machine so that I can get hold of a compatible version, but searching on MySQL website I found nothing older than 5.0.

I also tried MySQL workbench to connect to this database. Of failed with "Unknown character set utf8".

So how can I export the schema and data at all from this legacy MySQL database?

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.