database transfer problems

[BekahRuth]

I am trying to transfer my database from one server to another, and I followed all of the instructions for exporting your database and importing it to the new server. When I try to import it to the new server, I get this error:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"

Help please!

[kobra]

Do you know the mysql version of your old host and the version of the new?

[azrahn]

Hi,

Not sure if it will help you but this is what the manual states:

NO_AUTO_VALUE_ON_ZERO

NO_AUTO_VALUE_ON_ZERO affects handling of AUTO_INCREMENT columns. Normally, you generate the next sequence number for the column by inserting either NULL or 0 into it. NO_AUTO_VALUE_ON_ZERO suppresses this behavior for 0 so that only NULL generates the next sequence number.

This mode can be useful if 0 has been stored in a table's AUTO_INCREMENT column. (Storing 0 is not a recommended practice, by the way.) For example, if you dump the table with mysqldump and then reload it, MySQL normally generates new sequence numbers when it encounters the 0 values, resulting in a table with contents different from the one that was dumped. Enabling NO_AUTO_VALUE_ON_ZERO before reloading the dump file solves this problem. mysqldump now automatically includes in its output a statement that enables NO_AUTO_VALUE_ON_ZERO, to avoid this problem.

Ronald.

[DrByte]

It's not uncommon for an export/import from MySQL 3.23 to v4.x to lose all the auto-increment settings.
You may need to re-export your old database and specifically tell it to include auto-increment values. I believe that's done via a simple checkbox in phpMyAdmin. Or perhaps it's done via a v4-compatibility checkbox.

[BekahRuth]

Do you know the mysql version of your old host and the version of the new?

Old: 4.1.22
New: 4.0

[DrByte]

There's a fix-auto-increments.sql file in the zc_install/sql folder of your Zen Cart files, which "might" be a help to you if you cannot re-export with the auto-increment and/or compability options and then re-import.