Dump mysql based on omeka db.ini file

readme.md

Save the file on the server as ~/bin/dump and change the executable bit on it.

$ chmod +x ~/bin/dump

Then make sure ~/bin in your $PATH

$ export PATH=~/bin/:$PATH

Now, in an omeka project, run dump.

dump.sh

#! /usr/bin/env bash
path="."
CURDATE=$( date +%Y-%m-%d-%s )
DBUSER=$( cat ${path}/db.ini | grep "^username" | awk -F\" '{print $(NF-1)}' )
DBPASS=$( cat ${path}/db.ini | grep "^password" | awk -F\" '{print $(NF-1)}' )
DBNAME=$( cat ${path}/db.ini | grep "^dbname" | awk -F\" '{print $(NF-1)}' )
DBPREF=$( cat ${path}/db.ini | grep "^prefix" | awk -F\" '{print $(NF-1)}' )
DBHOST=$( cat ${path}/db.ini | grep "^host" | awk -F\" '{print $(NF-1)}' )
DBPORT=$( cat ${path}/db.ini | grep "^port" | awk -F\" '{print $(NF-1)}' )

echo "Dumping database"
mysqldump -h $DBHOST -u $DBUSER --password="$DBPASS" $DBNAME | gzip -c | cat > $DBNAME-$CURDATE.sql.gz

echo "Done"