SEO

#1 (**permalink**) 02-28-2008, 07:56 AM

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 (**permalink**) 02-28-2008, 07:56 AM

On 17 Jul 2006 01:47:35 -0700, mo@ekontrol.com wrote:
> 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?

Select the data you're interested into a separate table, and back up
that.

--
Mares eat oats, and does eat oats, and little lambs eat ivy,
A kid will eat ivy too, wouldn't you?

#3 (**permalink**) 02-28-2008, 07:56 AM

mo@ekontrol.com wrote:
> 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.

#4 (**permalink**) 02-28-2008, 07:57 AM

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

SEO

Backup a part of a table