Uncategorized31 Jul 2006 04:10 pm

AMB

Alex’s MySQL Backup

AMB is a script I wrote to backup all the mysql databases in my server. I will make the script more complex in the future.

Download

Howto

Download the script
Login as root and upload it to your server
Modify the variables in the script
Chmod the script to 775
Chmod your backup directory to 777
run ./amb.sh
add to your cron for nightly dump

Features v 1.0

  • Backs up database nighlty (if you run it by cron)
  • Keeps an archive of database for seven days
  • Compressed Sql file saves you disk space

One Response to “AMB”

  1. on 02 Aug 2006 at 6:45 pm   Devin

    Hello Alex, I had a look at your script and it is doing the opposite of what I want it to do.

    How can I dump the content of compressed GZ MySQL database back into its raw format? Ie. a bunch of file with MYD, MYI, and FRM extensions.

    I’m trying to do it with MySQL Server installed on my local Windows 2000 machine but so far, I am unsuccessful with my attempts.

    Thanks,

    Devin