GICT knowledge base
DEFAULT CHARSET=latin1 or collate latin1_general_ci NOT NULL default or TIMESTAMP errors on importing a database dump
Published
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
Related guides
Check MariaDB Versions and Compatibility on Shared Hosting
Check your actual MariaDB/MySQL server version, maintenance coverage and application requirements before requesting a shared-hosting upgrade or move.
MySQLHow to Monitor MySQL Database Server Performance
Learn how to monitor MySQL performance with 4 essential Linux command-line tools.
MySQLHow to secure MySQL connections with SSL on Ubuntu
MySQL allows remote connections and we must protect data transfer happeneing between servers with SSL. Follow this tutorial to learn how.
MySQLHow to set up High Availability WordPress with HyperDB
HyperDB is a drop-in plugin that allows you to set up High Availability WordPress site that can work with multiple database servers at once.