gaspower Posted November 1, 2007 Share Posted November 1, 2007 Hello, I am moving servers so I did a sql dump and when importing to new database on new server, I get this error. #1064 - You have an error in your SQL syntax near 'SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 10. I see in another post to remove all of the DEFAULT CHARSET=latin1 entries. I did this, but still get the above error. Do I also need to remove that line? Thanks JR Link to comment Share on other sites More sharing options...
gaspower Posted November 1, 2007 Author Share Posted November 1, 2007 Should have mentioned, original server Database: MySQL 5.0.27 PHP Version: 5.1.6 (Zend: 2.1.0) New server MySQL 3.23.58 PHP Version: 4.3.10 (Zend: 1.3.0) Thanks JR Link to comment Share on other sites More sharing options...
Guest Posted November 2, 2007 Share Posted November 2, 2007 If you can - export in3.2 version and then import back.If that fail then downolad a xampp.Start the apache and mysql and import the dbase to myslq.Then export in proper format.I had to do this way as I eported in wrong format at the first time.The xampp save my store. Link to comment Share on other sites More sharing options...
gaspower Posted November 2, 2007 Author Share Posted November 2, 2007 Thank you, I will try JR Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.