php - How to: Archive a Database -

Can someone tell me different ways to store MySQL database information? I want to save my database table and use the new information in the database first to use it as a collection, it is like backing up from my database. I want to know the best ways to do this.

What's the best way to do this?

Put all the data in the same table.
Storing data to a database is far more data than your thoughts.

Just add the date field to the table and you will be able to filter your records in the month - you will have to learn a little SQL for that.