Knowledge Base

How Can We Help?

DEFAULT CHARSET=latin1 or collate latin1_general_ci NOT NULL default or TIMESTAMP errors on importing a database dump

You are here:

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

or

mysqldump -u username -p –skip-extended-insert database_name > export_file_name.sql

Leave a Comment