Planet MySQL

Displaying posts with tag: MySQLForge (reset)

Mar

2010

MySQL: Partition-wise backups with mysqldump

Posted by Roland Bouman on Tue 30 Mar 2010 09:00 UTC
Tags:

Backup, MySQL UC, DBA, mysqlconf, partitioning, mysqldump, Giuseppe Maxia, information_schema, mysql conference, MySQLForge, MySQL command line tool, André Simões, MySQL command line client, MySQL

To whom it may concern,

in response to a query from André Simões (also known as ITXpander), I slapped together a MySQL script that outputs mysqldump commands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge. How it worksThe script works by querying the information_schema.PARTITIONS system view to …

[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links