Drupal Meetup at UNC Charlotte

shrop's picture
Start: 
2009-06-04 12:00 - 13:30 America/New_York
Organizers: 

Check out all the details here:

http://ucit01.uncc.edu/drupal-meetup

Meeting Notes and Related Links:

I have also posted the MySQL backup script that I use. Set the variables needed in the script and then create a dblist.txt with the names of each database to backup (one per line). I cron this to run each evening on my servers. Note: I am not the original author and I can't remember who to credit. If you know, let me know.

#!/bin/bash                                                                                                                                            

# Backup mysql databases

# Set a value that we can use for a datestamp
DATE=date +%Y-%m-%d                                                                                                                                            
# Our Base backup directory
BASEBACKUP="/folder/to/store/mysql/backups"

for DATABASE in cat dblist.txt
do
        # This is where we throw our backups.
        FILEDIR="$BASEBACKUP/$DATABASE"

        # Test to see if our backup directory exists.
        # If not, create it.
        if [ ! -d $FILEDIR ]
        then
                mkdir -p $FILEDIR
        fi

        echo -n "Exporting database:  $DATABASE"
        mysqldump --host=localhost --user='YourMySQLUser' --password='YourMySQLPW' --opt $DATABASE | gzip -c -9 > $FILEDIR/$DATABASE-$DATE.sql.gz
        echo "      ......[ Done ] "
done

# AutoPrune our backups.  This will find all files
# that are "MaxFileAge" days old and delete them.
MaxFileAge=30
find $BASEBACKUP -name '*.gz' -type f -mtime +$MaxFileAge -exec rm -f {} \;

AttachmentSize
Drupal Meetup Flyer.pdf576.55 KB
Login or register to post comments

How long do you think this

caschbre's picture
caschbre - Mon, 2009-06-01 10:47

How long do you think this event will run? I need to plan my extended lunch hour. :)


i am thinking 1-1.5 hrs. I

shrop's picture
shrop - Mon, 2009-06-01 10:51

i am thinking 1-1.5 hrs. I have the room for sure till 1:30pm. People can pop in and out though..totally no problem if you have to leave early.


would've liked to come

budesigns - Mon, 2009-06-08 20:00

...when's the next one?!


We don't have any plans

shrop's picture
shrop - Mon, 2009-06-08 21:06

We don't have any plans right now. The next might be Fall unless someone wants to go earlier..