How to backup by ignoring some tables but getting their schema?
Automatic MySQL Backup
Brought to you by:
wipe_out
Menu
▾
▴
#47 How to backup by ignoring some tables but getting their schema?
We are using AutoMySQLBackup on a lot of web servers hosting Drupal sites and for the backups we exclude all the cache tables. This is all working really nice but the prohblem is, when we have to restore a database - either to recover from a problem or locally for a developer - the database backup is missing the schema of the ignored tables.
Looking into the full schema files that get created, we run into different problems. First, they can easily be out of date. Second, they contain hard-coded database names. Third, they contain the full schema of every database and not only the one that we're interested in when trying to restore a particular one.
Maybe our setup is incomplete or not ideal?
What would be best for a potential restore scenario is to have the schema of all tables in the dump and the data of all tables that are not ignored.
Is there a way to get that automatically?
