On Mon, Jun 23, 2003 at 04:49:00PM -0700, Jeremy Zawodny wrote: > On Mon, Jun 23, 2003 at 04:16:51PM -0700, Hubbard, Dan wrote: > > Passing mysql commands through mysqldump or BACKUP TABLE ? > > > > We would like to perform backups on selective data within selective tables > > and then purge the matching data in those tables. Is it possible to pass > > mysql commands through either util above ? Which is better ? > > > > Example: sql statement... > > > > select * from tablename1 WHERE ((date_time > '2003-00-00 00:00:00') and > > (date_time < '2003-06-31 00:00:00')); > > No.
Hm. I somehow missed the mysqldump reference. As Don points out, you can do that. *sigh* I should have thought to mention it. Oh well... -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 20 days, processed 650,961,218 queries (360/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
