CODEWITHSUNDEEP
mysqlmampbackup-strategies
Chris Hough
Chris Hough

Reputation: 3558

how to backup your mamp pro mysql dbs?

while I find the apache portion of mamp pretty easy to backup, what is everyone using or how are you performing a scheduled backup of your mysql databases? It would be kinda annoying to export each DB one by one.

thank you

Upvotes: 2

Views: 4996

Answers (3)

Garegin Gyulasaryan
Garegin Gyulasaryan

Reputation: 11

$mysqldump --all-databases > mysql_dump.sql

Upvotes: 1

Jeff
Jeff

Reputation: 19

/MAMP/Libray/bin/mysqldump

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

Upvotes: 1

Miha Hribar
Miha Hribar

Reputation: 5791

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

Upvotes: 0

Related Questions