Comments on ZRM 2.1: Backing Up MySQL Partitioned Tables

ZRM 2.1: Backing Up MySQL Partitioned Tables MySQL 5.1 is generally available for production use. One of the key features of MySQL 5.1 is partitioning. This how to shows how to install and configure Zmanda Recovery Manager for MySQL (ZRM) 2.1 to perform backup and recovery of MySQL partitioned tables.

2 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Giuseppe Maxia
Reply  

Paddy,

You can simply use mysqldump to backup any 5.1 table, partitioned or otherwise.

Backup: 

mysqldump --opt db_name table_name > backup.dump
Restore: 
mysql db_name < backup.dump

Suggesting that you should use Zmanda for this task, without mentioning that the native tool is perfectly adequate, is misleading.

 If you want to promote your specific tool, please say so in the title.

Giuseppe

By:
Reply  

Guiseppe,

The title was supposed to be "ZRM 2.1: Backing up MySQL partitioned tables". Unfortunately, there was cut and paste error and I don't have permissions (or I don't know) how to edit the article. I have asked the editor to make the correction.

BTW, the article did not mention that backup/recovery could not be done using any other method.

Paddy