2

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

Chris Hough
  • 3,389
  • 3
  • 41
  • 80

3 Answers3

1

$mysqldump --all-databases > mysql_dump.sql

Garegin Gyulasaryan
  • 11
  • 1
1
/MAMP/Libray/bin/mysqldump

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

Cosmin
  • 21,216
  • 5
  • 45
  • 60
Jeff
  • 19
  • 3
  • As a total noob, could someone explain how I use this in a little more detail? I have no clue where to go from here... – norsewulf Jun 21 '13 at 16:35
0

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.

Miha Hribar
  • 5,776
  • 3
  • 26
  • 24
  • i tried that, however, either my script was wrong or it could not connect to mamp, it could not locate the mysqldump command – Chris Hough Sep 07 '09 at 22:27
  • Try installing macports and install mysqldump from the repository. Would need to check to see that the versions will be compatible though. I'm sorry but I don't use Mamp, I have installed everything either from macports or by hand. – Miha Hribar Sep 07 '09 at 22:39