Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
2  
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
1  
putty and bash eliminate SQL Server as a possible suspect. –  datagod Feb 27 '12 at 20:10
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.