Partition backup

[kay_rus]

I need to create a special archive zabbix server. For these purposes I need to backup old partitions on live zabbix and restore them on archive zabbix server. I use simple Mysql 5.1.61

I've found a partition backup utility xtrabackup:

http://www.percona.com/doc/percona-xtrabackup/howtos/recipes_ibkx_partition.html

And successfully backed up partitions for one month, but I was not able to restore them to clear database.

What I tried to do:
- mysqldump --all-databases --no-data > db.sql
- altered db.sql and removed unused partitions
- restored db.sql to archive mysql server
- stopped mysqld
- copied files generated by xtrabackup to /var/lib/mysql/zabbix_database
- started mysqld
- tried to execute select * from history_log limit 10; and got "mysql was lost" with "segfault" in mysqld.log

What I did wrong?

[kay_rus]

Maybe it is possible to implement replication only for data older two month?

[kay_rus]

I have found another solution for my task.

Use mysql proxy which will proxy queries to the live and archive DBs. UPDATE, ALTER and INSERT queries will be proxied to both DBs, and SELECT queries only to the live.

Someone had already done that?

[kay_rus]

Any suggestions?

[rsvancara]

Limitations

I think you are running into some of the many limitations that MySQL has. You might have to build a custom script that takes care of the replication or perform some kind of static dump every night that you import into the archive.