Make an archive DB

[jimmydorry]

• [ ] New MySQL instance with 8GB of RAM, and 400GB of disk space.
• [ ] Make cronjob to export old data to .sql archive file (do it based on absolute date, not a relative one... i.e. use first day of the week). Perhaps use PHP on web instance to do logic and run the export command for remote file location?
• [ ] Make cronjob to remove exported data from tables. Perhaps use PHP on web instance to do logic and run the command remotely?
• [ ] Make cronjob to move sql archive files to the new MySQL instance.
• [ ] Make cronjob to open and import data into database (we have data in a DB then, as well as in files).
• [ ] Make a database backup script for the main MySQL server, that creates a .sql archive and moves it to the SAN.