How can I make an automatic copy of a MySQL database to another MySQL database on the same server?

Wednesday, November 4, 2015

I have two MySQL databases called LIVE and REPORTS on the same server.



I want to copy the LIVE database and all its contents into the REPORTS database everyday at a specific time frame between 1 am and 5 am.



How could I do this manually and automatically?

0 comments:

Post a Comment