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

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.