Backup a part of a table

#1

Hello,

what is the recommendet way to backup only the rows of a single table
that have i.e. a timestamp older than 5 months?

Thanks!

Regards,

Martin O.

#2

mo (AT) ekontrol (DOT) com wrote:

Quote:

what is the recommendet way to backup only the rows of a single table
that have i.e. a timestamp older than 5 months?

mysqldump [options] --where="timestampcolumn < CURDATE() - INTERVAL 5
MONTH" databasename tablename

Regards,
Bill K.

#3

Thank you all for the answears. I will try with mysqldump ...
--where...

Regards,

Martin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Backup a part of a table

comp.databases.mysql comp.databases.mysql

Backup a part of a table - 07-17-2006 , 03:47 AM

Re: Backup a part of a table - 07-17-2006 , 12:37 PM

Re: Backup a part of a table - 07-21-2006 , 06:54 AM