On Tue, 20 Apr 2004, Lloyd thomas wrote: >Which is the best way to backup rows which meet a certain date criteria? >ie WHERE data is <= '2003-11-20'. >Would I need to select and save the data to a temporary table and then DUMP the temp >table. >
Just begin a transaction to get a snapshot of the database, then dump the data within the transaction. No temporary table needed. Will lock the database, but it is the only way to ensure a consistent view unless you are saving data from a single table or view, in which case you won't need the transaction. Christian -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]