Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#23 Patch to exclude particular tables

closed
nobody
None
5
2011-08-18
2010-12-18
Matt Gibson
No

I've got a couple of databases with small core tables but large cache tables, which I can easily rebuild if lost. This patch provides a new option to automysqlbackup of TABLEEXCLUDE. TABLEEXCLUDE should be a space-separated list of tables in the format DBNAME.TABLENAME, e.g.:

TABLEEXCLUDE="randombristol.pixel_coord_cache"

automysqlbackup will then pass these listed tables as mysqldump --ignore-table options when doing the backup, thus excluding these particular tables from the backup.

Matt

Discussion

  • Matt Gibson
    Matt Gibson
    2010-12-18

     
  • PittaGurneyi
    PittaGurneyi
    2011-08-18

    • status: open --> closed
     
  • PittaGurneyi
    PittaGurneyi
    2011-08-18

    Functionality included in version 3.0_beta. This patch however is a horrible idea of handling strings in bash. Just imagine what would happen if there were special characters or just spaces in the strings ...