Posted at January 1, 2015 at 12:00 am by InterServer Staff
Should you get one of the following errors on importing a MySQL database dump you are most likely dumping from a MySQL 4.1 server to a MySQL 4.0 server. There are some differences between the two. To get a correct dump format use the following method to create a mysqldump:
mysqldump -u username -p –skip-opt database_name > export_file_name.sql
mysqldump -u username -p –skip-extended-insert database_name > export_file_name.sql
You can skip to the end and leave a response. Pinging is currently not allowed.