hi there,
i’ve to move an ee installation to another server and have encountered some mysql errors while migrating the db to the new mysql host…
the mysql specs are as following:
Server A
MySQL: 4.1.10a
phpMyAdmin: 2.8.2.4
Server B
MySQL: 4.0.23a
phpMyAdmin: 2.6.0-pl3
when i try to upload the .sql from Server A whithin phpMyAdmin at Server B i get these errors:
#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 CHARSET=latin1 AUTO_INCREMENT=20' at line 2
if i delete all occurrences of “DEFAULT CHARSET=latin1”, i get:
#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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`comment` text
as you see i’m not really a mysql expert, so maybe you’ve a tip for me…i hope i can migrate the db just with the .sql file, otherwhise i’d have to install a clean copy of ee and pull all data in the db by hand!
btw: the server wizard succeeded in all criterias for Server B…
please help 
