Skip to content

Instantly share code, notes, and snippets.

@EdaCZ
Last active August 29, 2015 13:58
Show Gist options
  • Save EdaCZ/10168680 to your computer and use it in GitHub Desktop.
Save EdaCZ/10168680 to your computer and use it in GitHub Desktop.
#!/bin/bash
if [[ -z "$1" ]]
then
DBNAMES=('A' 'B' 'C')
else
DBNAMES=($1)
fi
cd '/home/eda/Server/adminer/backups'
for DBNAME in ${DBNAMES[*]}
do
SQLFILENAME=$DBNAME'.sql'
GZFILENAME=$SQLFILENAME".gz"
# rozbalime .gz, pokud existuje
if [ -f $GZFILENAME ]
then
echo 'rozbalovani' $GZFILENAME
gunzip $GZFILENAME -f
else
echo $GZFILENAME 'neexistuje'
fi
# importujeme sql, pokud existuje
if [ -f $SQLFILENAME ]
then
echo 'import:' $SQLFILENAME '->' $DBNAME
mysql -D $DBNAME -u XXX -pXXX < $SQLFILENAME
NEWNAME='_'$SQLFILENAME
mv $SQLFILENAME $NEWNAME # pred jmeno souboru dame podtrzitko
else
echo $SQLFILENAME 'neexistuje'
fi
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment