Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I exclude a specific table during a SQL backup RESTORE operation?

My question is specific to restoring a backup sql file.

I am using Putty and bash server.

share|improve this question
What engine? MySQL? Do you mean "restore, but don't overwrite current table" or "I don't want this table after restore"? – gbn Feb 27 '12 at 8:22
@myskny: which db server you are using it it mysql..? – Abdul Manaf Feb 27 '12 at 10:42
putty and bash eliminate SQL Server as a possible suspect. – datagod Feb 27 '12 at 20:10

You don't. You restore the backup as a new DB, drop the unwanted table from it, then take a new backup of this working DB.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.