Are there any mysql scripts for taking a database backup by excluding specified tables?
Also, what is the best way to take backup of a running mysql system?
asked Nov 30, 2011 at 9:29
-
What OS? Community or Enterprise? InnoDB or MyISAM or ... ?– gbnNov 30, 2011 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 EfreinNov 30, 2011 at 9:59
-
1possible duplicate of How do to mysqldump specific table(s)?– GaiusDec 16, 2011 at 22:45
Add a comment
|
1 Answer
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.
-
1
-
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. Dec 1, 2011 at 9:25
-
Thanks Cylindric..It worked for me for excluding one table..How to exclude more than one table Dec 5, 2011 at 5:17
-
-
1Like it says on the page I linked, "To ignore multiple tables, use this option multiple times." Dec 5, 2011 at 9:40