How to skip already created table while importing dump file in MySql

Posted on

Question :

Is there any way to skip already created tables while importing ? I am trying to import 2GB of database using command prompt but the operation is aborted by mistake. Now if i will do the import again it will drop each table and create it again, That will take very long time.

I want to skip those tables from import which is already created or can i start it from where it was aborted ? I am using this command

mysql -u root -p my_database_name < db_dump.sql

Answer :

--ignore-table=my_db_name.my_table_name my_db_name > dump.sql

Leave a Reply

Your email address will not be published. Required fields are marked *