MySQL How to import data from SQL file
Suppose you exported a SQL file from phpMyAdmin and you want to import to a local MySQL instance.
The data comes from a table post. You need to first delete the old table from your local instance.
drop table post;
Otherwise you get the duplicate entry error:
ERROR 1062 (23000) at line 53: Duplicate entry '91' for key 1
And then import the file, the table creation statements are already contained
The command to import the file is
mysql -uroot -p databasename < post.sql
If the file is big, you may get other errors like
ERROR 2013 (HY000) at line 729: Lost connection to MySQL server during query
ERROR 2006 (HY000) at line 729: MySQL server has gone away
You need to change the size of max_allowed_packet , the default is 1M. Change it to like 160M.