Tell me more ×
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.
up vote 1 down vote favorite

Are there any mysql scripts for taking a database backup, while excluding specified tables?

Also, what is the best way to take backup of a running mysql system?

Regards, Praveen

share|improve this question
What OS? Community or Enterprise? InnoDB or MyISAM or ... ? – gbn Nov 30 '11 at 9:54
If you are not sure, connect to MySQL, type use information_schema; and then type: select table_schema, table_name, engine from tables where table_schema='database_name'; – Craig Efrein Nov 30 '11 at 9:59
possible duplicate of How do to mysqldump specific table(s)? – Gaius Dec 16 '11 at 22:45

1 Answer

up vote 2 down vote accepted

You can backup databases and tables using the mysqldump command. There are parameters for excluding certain tables.

mysqldump -u username -ppasswword -h servername --ignore-table=dbname.tabletoskip dbname

If you need to get fast backups of MyISAM or ARCHIVE tables, you can also use mysqlhotcopy. That has more restrictions though.

share|improve this answer
This is as StraightForward an answer as possible. +1 !!! – RolandoMySQLDBA Nov 30 '11 at 18:20
Yeah, it is best to start with the simple solutions, and only work up to the complex home-brew scripts when you know you need it. – Cylindric Dec 1 '11 at 9:25
Thanks Cylindric..It worked for me for excluding one table..How to exclude more than one table – Praveen Dec 5 '11 at 5:17
Can we use this method for backing up a running DB – Praveen Dec 5 '11 at 5:31
Like it says on the page I linked, "To ignore multiple tables, use this option multiple times." – Cylindric Dec 5 '11 at 9:40

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.