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')); TIA !