- 1st create archive database (vervanger_archive) .
- 2nd at original
base if you dont have set DATE_ADD (adding timestamp for each row). - 3rd SET 1 cron task once upon a day to move OLD rows from Original
table to the archive table.
Creating tables with timestamp names is bad choice..
1
solved How to add date to MySQL table name? [closed]