Dumpinno : Exporter une base de données innodb

#!/bin/bash
#
# dumpinno
# Bash script allowing to export innodb database
# Disable foreign keys during import
#
# @author Patrick Poulain
# @licence GPL
# @see http://petitchevalroux.net
# Sample Usage :
# dumpinno.sh DATABASE ~/DATABASE.sql
# dumpinno.sh -u root DATABASE ~/DATABASE.sql
# dumpinno.sh -u root -p dummypassword DATABASE ~/DATABASE.sql
#

# function triggered when a wrong call is made
function usage() {
    echo "Usage: "`basename $0`" [-u dbuser][-p dbpassword] DATABASE FILE";
    exit 2;
}
# check if mysqldump exists
cmd=`which mysqldump`;
if [ -z "$cmd" ] || [ ! -x "$cmd" ]
then
    echo "Error : unable to find mysqldump command";
    exit 1;
fi
# get user and password options
while getopts u:p: name
do
    case $name in
        u)cmd="$cmd -u $OPTARG";;
        p)cmd="$cmd --password=$OPTARG";;
        ?) usage;;
esac
done

# get database and output file from arguments array
args=("$@");
file=${args[$OPTIND]};
database=${args[$OPTIND-1]};
# check if one of them is empty
if [ -z $file ] || [ -z $database ]
then
    usage;
fi
# disable innodb foreign keys check and autocommit
echo "SET AUTOCOMMIT = 0;SET FOREIGN_KEY_CHECKS=0;" > $file;
# dump database to a tmp file
$cmd -r $file.tmp $database;
# copy dump content to the final file
cat $file.tmp >> $file;
# delete temporary file
rm $file.tmp;
# reset foreign key check and commit
echo "SET FOREIGN_KEY_CHECKS = 1;COMMIT;SET AUTOCOMMIT = 1;" >> $file;

pcr@home:~$ vi ~/bin/dumpinno.sh

pcr@home:~$ chmod u+x ~/bin/dumpinno.sh

pcr@home:~$ ~/bin/dumpinno.sh -u mysql -p motdepasse MABASE export.sql

pcr@home:~$ mysql -u mysql -p motdepasse MABASE < export.sql