How to backup your mamp pro mysql dbs?

while i found the apache mamp part is pretty easy to back up what everyone is using or how do you do scheduled backups of your mysql databases? It would be very frustrating to export each DB one by one.

Thank you

+2


source to share


3 answers


/MAMP/Libray/bin/mysqldump 

      



You can add it to your path if you want to make cron work easier.

+1


source


$ mysqldump --all-databases> mysql_dump.sql



+1


source


You can write a simple cron that will export all the databases you want using mysqldump and then move them to a remote machine for storage using scp or some other mechanism.

0


source







All Articles