charlesdavison
01-11-2007, 09:00 PM
I'm trying to export several tables from my development server's PhpMyAdmin export function. When I import the SQL file to the live server, also through PhpMyAdmin, I get a syntax error.
I've been told this is because the live server is using an older version of MySQL. I've successfully tested exporting and importing the data to another server, so I know the syntax is OK, it must be using some commands not supported in all versions.
Is there any way I can easily convert the SQL to be compatible with older versions? I can't switch hosts or get the version upgraded, plus the only import option is SQL (no XML etc.)
Versions are below:
Exporting from MySQL version 4.1.9
Importing to version 3.23
The error generated is:
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ' at line 17
Grateful for any advice, thanks in advance
I've been told this is because the live server is using an older version of MySQL. I've successfully tested exporting and importing the data to another server, so I know the syntax is OK, it must be using some commands not supported in all versions.
Is there any way I can easily convert the SQL to be compatible with older versions? I can't switch hosts or get the version upgraded, plus the only import option is SQL (no XML etc.)
Versions are below:
Exporting from MySQL version 4.1.9
Importing to version 3.23
The error generated is:
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ' at line 17
Grateful for any advice, thanks in advance