Hello, I am trying to import a .sql file from my old host to my new host but the old host is not the same version of mysql that the new host is using. Old host mysql version: 4.1.21 New host mysql version: 4.0.27 Is there a way for me to conver the sql file from 4.1.21 to 4.0.27?
I would do a sql dump of your old host, then create a similar structure and fill it with garbage data on the new host. then do a SQL dump of that file and compare what the SQL differences are. Then modify your old sql dump file.