[decentplayboy]

Originally Posted by Dave

Unless you generated the database backup with the "IGNORE" option, there's no way to just let it skip half of the dump.

You got 3 options:
1. Delete the half restored database and start over.
2. Open the dump file and remove everything that has already been imported. Bit unpractical since it's hard to work with files of multiple gigs.
3. Look at where your database import stopped in something like PHPMyAdmin, then delete the most recent table that was imported (it always imports from A to Z, so delete the table that's at the bottom of the list) and re-export the database to include all the tables that are still missing.

Personally I would go for option 3.

Thanks dave. Option 3 is not possible as my existing database is corrupted. I have only the backup from mysqldump. I think i have no choice but only option 1. Btw, do you know any command to put in restore syntax to avoid interruption? I found that previous view time stop half way were due to connection lost

--------------- Added [DATE]1507421424[/DATE] at [TIME]1507421424[/TIME] ---------------

Is there a way to create a new sqldump file which exclude few table from my old sqldump file? If yes, what is the syntax to use? Thanks