One last thing... mysqldump has the following option: -w, --where=name Dump only... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

chadr on Jan 19, 2009 | parent | context | favorite | on: Ask HN: Archive a MySQL database

One last thing... mysqldump has the following option:

-w, --where=name Dump only selected records; QUOTES mandatory!

You can probably use this to backup just the rows you are interested in and then delete them once you are sure the are properly archived.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact