45 lines
1.5 KiB
Bash
Executable File
45 lines
1.5 KiB
Bash
Executable File
#!/bin/bash
|
|
|
|
#This program is free software: you can redistribute it and/or modify
|
|
#it under the terms of the GNU General Public License as published by
|
|
#the Free Software Foundation, either version 3 of the License, or
|
|
#(at your option) any later version.
|
|
#
|
|
#This program is distributed in the hope that it will be useful,
|
|
#but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
#GNU General Public License for more details.
|
|
#
|
|
#You should have received a copy of the GNU General Public License
|
|
#along with this program. If not, see <http://www.gnu.org/licenses/>
|
|
|
|
host='127.0.0.1'
|
|
database='cacti'
|
|
user='root'
|
|
outpath='/tmp/cacti'
|
|
|
|
read -s -p"$user DB password: " password
|
|
echo
|
|
tables=`mysql -u$user -p$password $database -h$host -N -B -e "show tables"`
|
|
if [ -z $tables ] ; then
|
|
echo "Cannot fetch DB tables"
|
|
exit 1
|
|
fi
|
|
|
|
#create output dir and change permission if needed
|
|
[ -d $outpath ] || mkdir $outpath
|
|
[ $(stat --printf='%a' $outpath) -ge 777 ] || chmod a+w $outpath
|
|
|
|
IFS='
|
|
'
|
|
success=true
|
|
for table in $tables ; do
|
|
mysql -u$user -p$password -h$host $database -N -B -e "select * from $table into outfile '$outpath/$table.csv' fields terminated by ';' enclosed by '\"'" || success=false
|
|
done
|
|
|
|
if $success ; then
|
|
echo "All tables of $database database have been successfuly dumped to csv files in $outpath"
|
|
else
|
|
echo "Errors encoutered while dumping $database database tables to $outpath"
|
|
fi
|