I am moving my shopping cart from one server to another. I hav taken a back up of my existing data using CPanel's inbuilt phpMyAdmin. When I try to restore this database again using phpMyAdmin, I receive the following error:
============
CODE
Error
SQL-query :
CREATE TABLE `CubeCart_Downloads` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customerId` int( 11 ) NOT NULL default '0',
`cart_order_id` varchar( 32 ) NOT NULL default '',
`noDownloads` int( 11 ) NOT NULL default '0',
`expire` int( 11 ) NOT NULL default '0',
`productId` int( 11 ) NOT NULL default '0',
`accessKey` varchar( 10 ) NOT NULL default '',
KEY `id` ( `id` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =28
MySQL said:
#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=28' at line 10
SQL-query :
CREATE TABLE `CubeCart_Downloads` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customerId` int( 11 ) NOT NULL default '0',
`cart_order_id` varchar( 32 ) NOT NULL default '',
`noDownloads` int( 11 ) NOT NULL default '0',
`expire` int( 11 ) NOT NULL default '0',
`productId` int( 11 ) NOT NULL default '0',
`accessKey` varchar( 10 ) NOT NULL default '',
KEY `id` ( `id` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =28
MySQL said:
#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=28' at line 10
============
Is the error due to the number specified for AUTO_INCREMENT? If so I notice all the table structures have certain number assigned as AUTO_INCREMENT = 'number'
Any help I receive would be highly appreciated. Thank You!
