Clever Geek Handbook

Mysqldump with concatenated tables

I need a mysqldump including data, but there are also a couple of tables in the database with a FEDERATED engine. Mysqldump also includes INSERTs for FEDERATED tables, which makes an exemaple "Duplicate entry" error (because the table is already filled with data).

I can drop the structure and data separately, and then drop the INSERT for the FEDERATED tables, but this is not exactly the same as "making automatic reliable backups"

How to back up and then restore Mysql databases using FEDERATED tables?

+1


source to share


1 answer


After a quick diff analysis, the solution is to compile your own patched version of mysqldump, which skips INSERTs for FEDERATED tables by default. I haven't tried applying it myself so YMMV.



http://bugs.mysql.com/bug.php?id=32038

+1


source






More articles:


All Articles