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?