I have to take snap shot based on some criteria. e.g. consider there is a table having column salary. i want to take the snapshot of table which contain only those rows whose salary is greater than 20000.
Can any body tell me how can i take snapshot in mysql based on some criteria?