MySQL Forums
Forum List  »  Data Recovery

Problems dump 4 to 5.5
Posted by: michel barreto
Date: August 23, 2013 02:01PM

Hi There,

I have a server with 4.0 mysql version innodb engine.

i need to migrate to other server with 5.5 version (linux) ok

i dump the full database using mysqldump, when i try to restore on the 5.5 server it has a problem, because the file generate in the 4.0 set the variable on the sql scritp TYPE=INNODB and mysql 5.5 accepts only ENGINE=INNODB format on the time table creation and it abort the process.

i search on google, call any friends and nothing! the sql file has 16 gigabytes. is not possible edit with an file editor.

error exemple:
nAdicao char(3) default '0',
nSeqAdic char(3) NOT NULL default '',
cFabricante varchar(60) NOT NULL default '',
vDescDi varchar(15) NOT NULL default '',
xPed int(6) NOT NULL default '0',
nItemPed int(6) NOT NULL default '0',
nDI varchar(12) NOT NULL default ''

ERROR 1064 (42000) at line 19: 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 'TYPE=InnoDB' at line 9

Ps: i did try to change TYPE TO ENGINE and its solve the problem.

can anybody help me?

Thanks a lot.


Options: ReplyQuote

Written By
Problems dump 4 to 5.5
August 23, 2013 02:01PM
August 24, 2013 04:15PM
August 24, 2013 09:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.