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.
CREATE TABLE tabadi ( 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 '' ) TYPE=InnoDB
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 solved the problem.
Can anybody help me? Thanks a lot.