If you enter the command...
mysqldump --help
you'll find a long listing of qualifiers that you can use with this, one
of which is -w (or --where=) which allows you to specify what you want
dumped.
HTH,
Ron
James wrote:
Hello,
I'm trying to get my brain around this problem. I have a data
Look at the output of mysqldump --help
-w, --where=nameDump only selected records;
-t, --no-create-info
-Original Message-
From: James
To: Mysql List
Sent: 6/16/04 8:56 AM
Subject: dump data based on query
Hello,
I'm trying to get my brain around this problem. I have a dat
Hello,
I'm trying to get my brain around this problem. I have a database that
stores news articles. This database grows and grows, and I need a way
to archive older articles, preferably in a "dump" format similar to that
produced mysqldump. Is there a way to do a mysqldump based on a query,
