TRUNCATE TABLE backupTable;
INSERT INTO backupTable SELECT * FROM mainTable WHERE datefield >= xxxx

INSERT INTO backupTable SELECT * FROM mainTable WHERE 'backedUp' = 0;