Free Myspace Layouts - Investing - Free Advertising - Proxy Myspace - Loans
PDA

View Full Version : Changed Webservers - MySQL backup problem

netaddict
Sep 28th 2005, 7:48 am
I changed my servers.

I was uploading the MySQL backup on the new server and the following error is coming:

#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=7' at line 27

MySql version on my previous host: 4.1.13-standard
MySql version on new server: 4.0.25-standard

How can I make this database working?

Please help!!!
JoeO
Sep 28th 2005, 8:06 am
Did you export from phpmyadmin? If so you can choose to make the export compatable with older versions... I had the same problem a couple weeks ago.
netaddict
Sep 28th 2005, 8:28 am
Did you export from phpmyadmin? If so you can choose to make the export compatable with older versions... I had the same problem a couple weeks ago.

Thanks a lot man. I worked it out :) Kudos to you.... thanks again :p