Problem Importing SQL database to new database ready for testing Zencart 1.5

[RodG]

When doing the Export - configure the "Object creation options" as follows:

Add statements:
Add CREATE DATABASE / USE statement -tick
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement - tick
Add CREATE PROCEDURE / FUNCTION / EVENT statement -untick
CREATE TABLE options: -tick
IF NOT EXISTS -tick
AUTO_INCREMENT -untick



Cheers
RodG

[gillpotsoffun]

I am on PHP 5.3.3 and I have tried you Object Creation Options, but still have the same error message. The settings I am using are:

Output - inputting file name, no compression and leaving all other settings as default
Format - sql
Format Specific options - Structure and Data
Object Creation options - have tried both checking all options and also RodG suggestions but getting same error
Data Dump- INSERT and "both of the above" checked, and then all the defaults

[lhungil]

What version of phpMyAdmin are you using (the top of the SQL dump will usually indicate the version and other information unless disabled when exporting)?

It looks like the export snippet you supplied is not including the definition for the primary key of the table (thus the error message when trying to import).

There was a bug in certain obsolete versions of phpMyAdmin which resulted in broken exports such as your example snippet (auto_increment in the column definition of the table, but primary key not specified inside the table definition).