How to import mysql-4-dump file into mysql-5

From Servage Wiki
Jump to: navigation, search

While importing, you can come across the below error :

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 'TYPE=MyISAM'

Solution :

Download the .sql file to your local machine, open the file in Notepad. Change all instances of TYPE=MyISAM To ENGINE=MyISAM and save the file. Upload the file and try to import ( now, this will fix the error.

Personal tools