SQL Problems

[Guest moonsoft]

I am having a tough time using the cpanel 10 backup feature to down load an sql dump and move it to another site. heres the error i get when i try and upload it

i can NOT use the cpanel restore option for any of the cube cart databases, it stops durring dump it seems, or there is something not compatible.. i am just not sure i coul use someones help with this

--------------

DROP TABLE IF EXISTS CubeCart_Downloads

--------------

--------------

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)

) TYPE=MyISAM

--------------

--------------

DROP TABLE IF EXISTS CubeCart_Modules

--------------

--------------

CREATE TABLE CubeCart_Modules (

moduleId int(11) NOT NULL auto_increment,

module varchar(10) NOT NULL default '',

folder varchar(30) NOT NULL default '',

status smallint(1) NOT NULL default '0',

default int(1) NOT NULL default '0',

KEY moduleId (moduleId)

) TYPE=MyISAM

--------------

It seems like it's stopped for some reason it never gets past the first table.... anyone have an answer.. i am stumped and so are the network specialists at the data center. heres the answer they gave. I could use some insight

I have updated mysqldump program in the server. So the problem should be fixed now. Also you have to review your MySQL table creation queries and ensure that they are not deprecated. The deprecated table structures can still create this problem.

Sincerely,

Aaron Moon

MoonSoft Systems

[email protected]

[Guest]

You need to either pass the "--allow-keywords" option to mysqldump or use PHPMyAdmin to do the dump...it sets that by default. The main difference is that it will enclose all table names and field names in backticks. This keeps the parser from freaking out and not importing properly. :wacko: