Import:
$ mysql -u username -p databasename < path/example.sql
How to make backup of mysql table:
Creating an Empty Table
CREATE TABLE new_table LIKE original_table;
Inserting Data into Table
INSERT new_table SELECT * FROM original_table;
$ mysql -u username -p databasename < path/example.sql
Export:
$ mysqldump -u username -p databasename tableName > path/example.sql
How to make backup of mysql table:
Creating an Empty Table
CREATE TABLE new_table LIKE original_table;
Inserting Data into Table
INSERT new_table SELECT * FROM original_table;
