I have a DataObject that after a time needs to be archived. The way I had thought of doing this is just moving the table row for the object into another database table kind of like how versions or the live and draft works. However I don't know how those things are accomplished. Would I create a new DataObject and copy all the data from the old one to the new ArchiveDataObject? Or can I just cast on to another?

Is there a mysql command for moving table rows from one table to another?