Results 1 to 3 of 3

Thread: Automatic MySQL Backup Script

  1. #1

    Automatic MySQL Backup Script

    I modified crouse's mysql backup script with some modifications and have been using it for a few weeks. It saved my tush yesterday, so I thought I'd share it.

    It stores backup files in the directory /var/backups/mysql that it automatically creates. It also only backs up if MySQL is running by checking for the lock file.

    The nice thing about it is that you don't have to specify the names of the databases. It figures it out by itself.

    Stick it in cron, and make sure you have enough space in /var !

    You run it like this:

    Code:
    # mysql-backup <root-username> <root-password>
    The code looks like this:

    Code:
    #!/bin/bash 
    
    LOCK_FILE="/var/lock/subsys/mysqld"
    
    # Create the backup directory if it doesn't already exist
    
    if [ ! -d /var/backups/mysql ]; then
         mkdir -p /var/backups/mysql
    fi
    
    # Do backups
    
    if [ -f "$LOCK_FILE" ]; then
    
        # Do MySQL backups
    
        for i in `/usr/bin/mysql -B -u $1 -e 'show databases' -p$2 | /bin/grep -v Database`; do
            /usr/bin/mysqldump --opt -u $1 -p$2 $i | gzip > /var/backups/mysql/$i.`date --iso-8601`.sql.gz
        done
    
    fi

  2. #2
    Thanks!

    Perhaps we should add this to the Wiki?
    My crime is that of curiosity. My crime is that of judging people by what they say and think, not what they look like. My crime is that of outsmarting you, something that you will never forgive.

  3. #3
    OK, it's done! You can find it here.

Similar Threads

  1. Automated MySQL Database backup Script-on timely basis
    By linuxdepro in forum Linux - General Topics
    Replies: 2
    Last Post: 10-28-2013, 09:22 AM
  2. Automatic MySQL Backup Script
    By peter in forum Tutorials
    Replies: 1
    Last Post: 09-22-2009, 09:13 AM
  3. mysql backup
    By svar in forum Linux - General Topics
    Replies: 2
    Last Post: 01-01-2009, 07:16 AM
  4. MySQl backup script
    By girlygeek in forum Programming
    Replies: 5
    Last Post: 11-11-2006, 11:23 PM
  5. mysql backup
    By elovkoff in forum Linux - Hardware, Networking & Security
    Replies: 28
    Last Post: 08-13-2004, 02:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •