how can I backup my whole database periodically in Mysql?
posted 1 year ago
I have a server with 4 database. I would like to export 1 of the 4 database once a day.
I would like to export table creaion script as well as table data insert script once a day and either send the .sql file in my google drive or from my local directory. I really do not have an idea how to do this. Can this be done in mysql workbench?
Can someone please provide me what to search or guide? Noobie here. TIA