I am currently trying to find a way to automatically restore a dump.sql file to another server weekly. I haven't found the code to do this yet in either mysql or command prompt but I am looking. The main problem I can see is that the server creates two database backups each day one for each database and the name changes each day because we store the date in the name.
Is it possible to set up some code that restores the newest file for each database once a month?
I have done a lot of research but I keep finding guides on how to create the dump files or how to upload a single dump file to a new database but can't find anything on this.