In MySQL we can perform terminal backups as follows:
mysqldump nomeBaseDados > meuFicheiroBackup.sql
mysqldump nomeBaseDados nomeTabela > meuFicheiroBackupDaTabelaX.sql
How can I back up all tables in my nomeBaseDados database except for a tabelaCorrupta ?
mysqldump has a flag exactly for this:
--ignore-table
Example Usage:
mysqldump -u username -p database --ignore-table=meubanco.tabelaCorrupta > database.sql
Remembering that, if necessary, you can use --ignore-table more than once:
mysqldump -u username -p database --ignore-table=db.tab1 --ignore-table=db.tab2 ...
See more at manual .