Дамп данных

Дамп каждой таблицы MySQL в отдельный файл

Синтаксис: ./eachtable.sh <DB_HOST> <DB_USER> <DB_NAME> [<DIR>]

Пароль спрашивается при выполнении.

eachtable.sh
#!/bin/bash
 
# dump-tables-mysql.sh
# Descr: Dump MySQL table data into separate SQL files for a specified database.
# Usage: Run without args for usage info.
# Author: @Trutane
# Ref: http://stackoverflow.com/q/3669121/138325
# Notes:
#  * Script will prompt for password for db access.
#  * Output files are compressed and saved in the current working dir, unless DIR is
#    specified on command-line.
 
[ $# -lt 3 ] && echo "Usage: $(basename $0) <DB_HOST> <DB_USER> <DB_NAME> [<DIR>]" && exit 1
 
DB_host=$1
DB_user=$2
DB=$3
DIR=$4
 
[ -n "$DIR" ] || DIR=.
test -d $DIR || mkdir -p $DIR
 
echo -n "DB password: "
read -s DB_pass
echo
echo "Dumping tables into separate SQL command files for database '$DB' into dir=$DIR"
 
tbl_count=0
 
for t in $(mysql -NBA -h $DB_host -u $DB_user -p$DB_pass -D $DB -e 'show tables')
do
    echo "DUMPING TABLE: $t"
    mysqldump -h $DB_host -u $DB_user -p$DB_pass $DB $t | gzip > $DIR/$t.sql.gz
    (( tbl_count++ ))
done
 
echo "$tbl_count tables dumped from database '$DB' into dir=$DIR"

Или вот такой скрипт всех таблиц вида «b_iblock_» из базы данных Bitrix «db_name»:

inline_dump_table.sh
#!/bin/bash
db_name='db_name';mysql -N information_schema -e \
"select table_name from tables where table_schema = '$db_name' and table_name like 'b_iblock_%'" | \
while read db_table; do; echo $db_table; mysqldump $db_name $db_table > $db_table.sql; done