MySQL stored procedure create database by month I'm a systems admin, and I'm not a dba, I'm wondering if I could use MySQL stored procedure to
Query main database and move records by month to another database located on the same system.   

This way we can maintain database small main database, and have data moved to individual database by month. 

Thank you
I would advice you to take a look at partitioning if you are running a recent version of MySQL and see if this could solve your problem. 

Partitioning does not result in a smaller database but offers many of the same benefits with less administration once it is set up, and you will still have access to historic data.