Any assistance would be greatly appreciated. I'm relatively new to working with MySQL.
I exported my DB with phpMyAdmin 2.6.0-pl3 running MySQL 4.1.7
I'm trying to import it with phpMyAdmin 2.5.7-pl1 running MySQL 4.0.20
Is this possible? I seem to be getting this error:
MySQL said:
SQL-query :
CREATE DATABASE `win2ksh_aspsupport` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
MySQL said:
#1064 - 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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
Is it an issue with versions of MySQL and backwards compatibility?
Thanks, I appreciate the help.
~Newbie Nick
--
Message posted via http://www.mysqlmonster.com