blocks|key|934441|text|我不是bash高手，但我会使用bash脚本。在不使用MySQL的情况下，只要知道数据目录和数据库名称，就可以扫描所有的.frm文件(该db/目录中的每个表一个)，以获得一个表列表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|934442|我相信有办法让它变得更圆滑，接受争论或诸如此类的东西，但这对我来说效果很好。|934443|tables_in_a_db_to_sql.sh|934444|#!/bin/bash

database="this_is_my_database"
datadir="/var/lib/mysql/"
datadir_escaped="\/var\/lib\/mysql\/"

all_tables=($(ls+$datadir$database/*.frm+%7C+sed+s/"$datadir_escaped$database\/"/""/g+%7C+sed+s/.frm//g))

for+t+in+"${all_tables[@]}";+do
++++++++outfile=$database.$t.sql
++++++++echo+"--+backing+up+$t+to+$outfile"
++++++++echo+"mysqldump+[options]+$database+$t+>+$outfile"
++++++++#+mysqldump+[options]+$database+$t+>+$outfile
done|code-block|syntax|javascript|934445|根据需要填写选项和所需的输出文件约定，并取消对最后一行mysqldump的注释。|934446|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I'm not bash master, but I'd just do it with a bash script. Without hitting MySQL, with knowledge of the data directory and database name, you could just scan for all .frm files (one for every table in that db/directory) for a list of tables. 

I'm sure there are ways to make it slicker and accept arguments or whatnot, but this worked well for me.

tables_in_a_db_to_sql.sh

<pre><code>#!/bin/bash

database="this_is_my_database"
datadir="/var/lib/mysql/"
datadir_escaped="\/var\/lib\/mysql\/"

all_tables=($(ls $datadir$database/*.frm | sed s/"$datadir_escaped$database\/"/""/g | sed s/.frm//g))

for t in "${all_tables[@]}"; do
 outfile=$database.$t.sql
 echo "-- backing up $t to $outfile"
 echo "mysqldump [options] $database $t &gt; $outfile"
 # mysqldump [options] $database $t &gt; $outfile
done
</code></pre>

Fill in the [options] and desired outfile convention as you need, and uncomment the last mysqldump line.

blocks|key|1148851|text|mysqldump命令行程序会为您完成这项工作--尽管the+docs对此并不清楚。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1148852|需要注意的一件事是，拥有mysqld的用户必须能够写入~/output/dir。在Mac+OS+X上：|1148853|sudo+chown+-R+_mysqld:_mysqld+~/output/dir
mysqldump+--user=dbuser+--password+--tab=~/output/dir+dbname|code-block|syntax|javascript|1148854|运行上述程序后，您将拥有一个包含每个表的模式(create+table语句)的tablename.sql文件和包含数据的tablename.txt文件。|1148855|如果您只想使用模式转储，请添加--no-data标志：|1148856|mysqldump+--user=dbuser+--password+--no-data+--tab=~/output/dir+dbname|1148857|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html^0|R|8|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|13|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|C|$]]|$1|O|3|P|5|H|7|16|8|@]|9|@]|C|$I|J]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

The mysqldump command line program does this for you - although <a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html" rel="noreferrer">the docs</a> are very unclear about this.

One thing to note is that ~/output/dir has to be writable by the user that owns mysqld. On Mac OS X:

<pre><code>sudo chown -R _mysqld:_mysqld ~/output/dir
mysqldump --user=dbuser --password --tab=~/output/dir dbname
</code></pre>

After running the above, you will have one tablename.sql file containing each table's schema (create table statement) and tablename.txt file containing the data.

If you want a dump with schema only, add the --no-data flag:

<pre><code>mysqldump --user=dbuser --password --no-data --tab=~/output/dir dbname
</code></pre>

blocks|key|934519|text|下面的脚本将表数据作为SQL命令转储到单独的压缩文件中。它不需要位于MySQL服务器主机上，也不会在脚本中硬编码密码，并且只针对特定的数据库，而不是服务器上的所有数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|934520|#!/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"+]+%7C%7C+DIR=.
test+-d+$DIR+%7C%7C+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:+$DB.$t"
++++mysqldump+-h+$DB_host+-u+$DB_user+-p$DB_pass+$DB+$t+%7C+gzip+>+$DIR/$DB.$t.sql.gz
++++tbl_count=$((+tbl_count+%2B+1+))
done

echo+"$tbl_count+tables+dumped+from+database+'$DB'+into+dir=$DIR"|code-block|syntax|javascript|934521|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's a script that dumps table data as SQL commands into separate, compressed files. It does not require being on the MySQL server host, doesn't hard-code the password in the script, and is just for a specific db, not all db's on the server:

<pre><code>#!/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 ] &amp;&amp; echo "Usage: $(basename $0) &lt;DB_HOST&gt; &lt;DB_USER&gt; &lt;DB_NAME&gt; [&lt;DIR&gt;]" &amp;&amp; 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: $DB.$t"
 mysqldump -h $DB_host -u $DB_user -p$DB_pass $DB $t | gzip &gt; $DIR/$DB.$t.sql.gz
 tbl_count=$(( tbl_count + 1 ))
done

echo "$tbl_count tables dumped from database '$DB' into dir=$DIR"
</code></pre>

blocks|key|1148909|text|下面是相应的导入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1148910|#!/bin/bash

#+import-files-mysql.sh
#+Descr:+Import+separate+SQL+files+for+a+specified+database.
#+Usage:+Run+without+args+for+usage+info.
#+Author:+Will+Rubel
#+Notes:
#++*+Script+will+prompt+for+password+for+db+access.

[+$#+-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

DIR=$DIR/*


echo+-n+"DB+password:+"
read+-s+DB_pass
echo
echo+"Importing+separate+SQL+command+files+for+database+'$DB'+into+'$DB'"

file_count=0


for+f+in+$DIR

do+
++++echo+"IMPORTING+FILE:+$f"

++++gunzip+-c+$f+%7C+mysql+-h+$DB_host+-u+$DB_user+-p$DB_pass+$DB

++++((+file_count%2B%2B+))
done

echo+"$file_count+files+importing+to+database+'$DB'"|code-block|syntax|javascript|1148911|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here is the corresponding import.

<pre><code>#!/bin/bash

# import-files-mysql.sh
# Descr: Import separate SQL files for a specified database.
# Usage: Run without args for usage info.
# Author: Will Rubel
# Notes:
# * Script will prompt for password for db access.

[ $# -lt 3 ] &amp;&amp; echo "Usage: $(basename $0) &lt;DB_HOST&gt; &lt;DB_USER&gt; &lt;DB_NAME&gt; [&lt;DIR&gt;]" &amp;&amp; exit 1

DB_host=$1
DB_user=$2
DB=$3
DIR=$4

DIR=$DIR/*


echo -n "DB password: "
read -s DB_pass
echo
echo "Importing separate SQL command files for database '$DB' into '$DB'"

file_count=0


for f in $DIR

do 
 echo "IMPORTING FILE: $f"

 gunzip -c $f | mysql -h $DB_host -u $DB_user -p$DB_pass $DB

 (( file_count++ ))
done

echo "$file_count files importing to database '$DB'"
</code></pre>

blocks|key|934581|text|看起来这里的每个人都忘记了autocommit=0;SET+unique_checks=0;SET+foreign_key_checks=0;，它被认为可以加速导入过程……|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|934582|#!/bin/bash
MYSQL_USER="USER"
MYSQL_PASS="PASS"

if+[+-z+"$1"+]
++then
++++echo+"Dumping+all+DB+...+in+separate+files"
++++for+I+in+$(mysql+-u+$MYSQL_USER+--password=$MYSQL_PASS+-e+'show+databases'+-s+--skip-column-names);+
++++do+
++++++echo+"SET+autocommit=0;SET+unique_checks=0;SET+foreign_key_checks=0;"+>+"$I.sql"
++++++mysqldump+-u+$MYSQL_USER+--password=$MYSQL_PASS+$I+>>+"$I.sql";+
++++++echo+"SET+autocommit=1;SET+unique_checks=1;SET+foreign_key_checks=1;commit;"+>>+"$I.sql"
++++++gzip+"$I.sql"
++++done
++++echo+"END."
else
++++++echo+"Dumping+$1+..."
++++++echo+"SET+autocommit=0;SET+unique_checks=0;SET+foreign_key_checks=0;"+>+"$1.sql"
++++++mysqldump+-u+$MYSQL_USER+--password=$MYSQL_PASS+$1+>>+"$1.sql";+
++++++echo+"SET+autocommit=1;SET+unique_checks=1;SET+foreign_key_checks=1;commit;"+>>+"$1.sql"
++++++gzip+"$1.sql"
fi|code-block|syntax|javascript|934583|entityMap^0|D|1M|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

It looks everybody here forgot of <code>autocommit=0;SET unique_checks=0;SET foreign_key_checks=0;</code> that is suppose to speed up the import process ...

<pre><code>#!/bin/bash
MYSQL_USER="USER"
MYSQL_PASS="PASS"

if [ -z "$1" ]
 then
 echo "Dumping all DB ... in separate files"
 for I in $(mysql -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases' -s --skip-column-names); 
 do 
 echo "SET autocommit=0;SET unique_checks=0;SET foreign_key_checks=0;" &gt; "$I.sql"
 mysqldump -u $MYSQL_USER --password=$MYSQL_PASS $I &gt;&gt; "$I.sql"; 
 echo "SET autocommit=1;SET unique_checks=1;SET foreign_key_checks=1;commit;" &gt;&gt; "$I.sql"
 gzip "$I.sql"
 done
 echo "END."
else
 echo "Dumping $1 ..."
 echo "SET autocommit=0;SET unique_checks=0;SET foreign_key_checks=0;" &gt; "$1.sql"
 mysqldump -u $MYSQL_USER --password=$MYSQL_PASS $1 &gt;&gt; "$1.sql"; 
 echo "SET autocommit=1;SET unique_checks=1;SET foreign_key_checks=1;commit;" &gt;&gt; "$1.sql"
 gzip "$1.sql"
fi
</code></pre>

blocks|key|1148953|text|#!/bin/bash

for+i+in+$(mysql+-uUser+-pPASSWORD+DATABASE+-e+"show+tables;"%7Cgrep+-v+Tables_in_);do+mysqldump+-uUSER+-pPASSWORD+DATABASE+$i+>+/backup/dir/$i".sql";done

tar+-cjf+"backup_mysql_"$(date+%2B'%25Y%25m%25d')".tar.bz2"+/backup/dir/*.sql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1148954|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>#!/bin/bash

for i in $(mysql -uUser -pPASSWORD DATABASE -e "show tables;"|grep -v Tables_in_);do mysqldump -uUSER -pPASSWORD DATABASE $i &gt; /backup/dir/$i".sql";done

tar -cjf "backup_mysql_"$(date +'%Y%m%d')".tar.bz2" /backup/dir/*.sql
</code></pre>

blocks|key|934662|text|如果你想转储所有数据库中的所有表，只需结合Elias+Torres+Arroyo和Trutane的答案:如果你不想在终端上提供密码，只需将你的密码存储在一个额外的配置文件(Chmod0600)中--参见Mysqldump+launched+by+cron+and+password+security|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|934663|#!/bin/bash

#+this+file
#+a)+gets+all+databases+from+mysql
#+b)+gets+all+tables+from+all+databases+in+a)
#+c)+creates+subfolders+for+every+database+in+a)
#+d)+dumps+every+table+from+b)+in+a+single+file

++++#+this+is+a+mixture+of+scripts+from+Trutane+(http://stackoverflow.com/q/3669121/138325)+
++++#+and+Elias+Torres+Arroyo+(https://stackoverflow.com/a/14711298/8398149)

#+usage:+
#+sk-db.bash+parameters
#+where+pararmeters+are:

#+d+"dbs+to+leave"
#+t+"+tables+to+leave"
#+u+"user+who+connects+to+database"
#+h+"db+host"
#+f+"/backup/folder"



user='root'
host='localhost'
backup_folder=''
leave_dbs=(information_schema+mysql)
leave_tables=()
while+getopts+":d:t:u:h:f:"+opt;+do
++case+$opt+in
++++d)+leave_dbs=(+$OPTARG+)
++++;;
++++t)+leave_tables=(+$OPTARG+)
++++;;
++++u)+user=$OPTARG
++++;;
++++h)+host=$OPTARG
++++;;
++++f)+backup_folder=$OPTARG
++++;;

++++\?)+echo+"Invalid+option+-$OPTARG"+>&2
++++;;
++esac
done
echo+'****************************************'
echo+"Database+Backup+with+these+options"
echo+"Host+$host"
echo+"User+$user"
echo+"Backup+in+$backup_folder"
echo+'----------------------------------------'
echo+"Databases+to+emit:"
printf+"%25s\n"+"${leave_dbs[@]}"
echo+'----------------------------------------'
echo+"Tables+to+emit:"
printf+"%25s\n"+"${leave_tables[@]}"
echo+'----------------------------------------'


BACKUP_DIR=$backup_folder/$(date+%2B%25Y-%25m-%25dT%25H_%25M_%25S);
CONFIG_FILE=/root/db-config.cnf

function+contains()+{
++++local+n=$#
++++local+value=${!n}
++++for+((i=1;i+<+$#;i%2B%2B))+{
++++++++if+[+"${!i}"+==+"${value}"+];+then
++++++++++++echo+"y"
++++++++++++return+0
++++++++fi
++++}
++++echo+"n"
++++return+1
}


test+-d+"$BACKUP_DIR"+%7C%7C+mkdir+-p+"$BACKUP_DIR"
#+Get+the+database+list,+exclude+information_schema
database_count=0
tbl_count=0

for+db+in+$(mysql+--defaults-extra-file=$CONFIG_FILE+-B+-s+-u+$user+-e+'show+databases'+)
do
++++if+[+$(contains+"${leave_dbs[@]}"+"$db")+==+"y"+];+then
++++++++echo+"leave+database+$db+as+requested"
++++else

+++++++#+dump+each+database+in+a+separate+file
+++++++((+database_count%2B%2B+))
+++++++DIR=$BACKUP_DIR/$db
+++++++[+-n+"$DIR"+]+%7C%7C+DIR=.

+++++++test+-d+$DIR+%7C%7C+mkdir+-p+$DIR

+++++++echo
+++++++echo+"Dumping+tables+into+separate+SQL+command+files+for+database+'$db'+into+dir=$DIR"

+++++++for+t+in+$(mysql+--defaults-extra-file=$CONFIG_FILE+-NBA+-h+$host+-u+$user+-D+$db+-e+'show+tables')
+++++++do
+++++++++++if+[+$(contains+"${leave_tables[@]}"+"$db.$t")+==+"y"+];+then
+++++++++++++++echo+"leave+table+$db.$t+as+requested"
+++++++++++else
+++++++++++++++echo+"DUMPING+TABLE:+$db.$t"
++#++++++++++++mysqldump+--defaults-extra-file=$CONFIG_FILE+-h+$host+-u+$user+$db+$t++>+$DIR/$db.$t.sql
+++++++++++++++tbl_count=$((+tbl_count+%2B+1+))
+++++++++++fi
+++++++done

+++++++echo+"Database+$db+is+finished"
+++++++echo+'----------------------------------------'

++++fi
done
echo+'----------------------------------------'
echo+"Backup+completed"
echo+'**********************************************'|code-block|syntax|javascript|934664|而且，这也是有帮助的：|934665|Check+if+bash+array+contains+value|934666|arrays+in+bash|934667|named+arguments+in+script|934668|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/6861355/mysqldump-launched-by-cron-and-password-security|1|https://stackoverflow.com/questions/3685970/check-if-a-bash-array-contains-a-value|2|https://stackoverflow.com/questions/17232526/how-to-pass-an-array-argument-to-the-bash-script|3|https://unix.stackexchange.com/questions/129391/passing-named-arguments-to-shell-scripts/204927^0|2T|1C|0|0|0|0|0|Y|1|0|0|E|2|0|0|P|3|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|19|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|M|3|N|5|6|7|1E|8|@]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|O|3|P|5|6|7|1I|8|@]|9|@$A|1J|B|1K|1|1L]]|C|$]]|$1|Q|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]|Y|$5|T|U|V|C|$W|Z]]|10|$5|T|U|V|C|$W|11]]|12|$5|T|U|V|C|$W|13]]]]

If You want to dump all tables from all databases just combine Elias Torres Arroyo's and Trutane's answer:
And if You don't want to give Your password on terminal, just store Your password in an extra config file (chmod 0600)- see <a href="https://stackoverflow.com/questions/6861355/mysqldump-launched-by-cron-and-password-security">Mysqldump launched by cron and password security</a>

<pre><code>#!/bin/bash

# this file
# a) gets all databases from mysql
# b) gets all tables from all databases in a)
# c) creates subfolders for every database in a)
# d) dumps every table from b) in a single file

 # this is a mixture of scripts from Trutane (http://stackoverflow.com/q/3669121/138325) 
 # and Elias Torres Arroyo (https://stackoverflow.com/a/14711298/8398149)

# usage: 
# sk-db.bash parameters
# where pararmeters are:

# d "dbs to leave"
# t " tables to leave"
# u "user who connects to database"
# h "db host"
# f "/backup/folder"



user='root'
host='localhost'
backup_folder=''
leave_dbs=(information_schema mysql)
leave_tables=()
while getopts ":d:t:u:h:f:" opt; do
 case $opt in
 d) leave_dbs=( $OPTARG )
 ;;
 t) leave_tables=( $OPTARG )
 ;;
 u) user=$OPTARG
 ;;
 h) host=$OPTARG
 ;;
 f) backup_folder=$OPTARG
 ;;

 \?) echo "Invalid option -$OPTARG" &gt;&amp;2
 ;;
 esac
done
echo '****************************************'
echo "Database Backup with these options"
echo "Host $host"
echo "User $user"
echo "Backup in $backup_folder"
echo '----------------------------------------'
echo "Databases to emit:"
printf "%s\n" "${leave_dbs[@]}"
echo '----------------------------------------'
echo "Tables to emit:"
printf "%s\n" "${leave_tables[@]}"
echo '----------------------------------------'


BACKUP_DIR=$backup_folder/$(date +%Y-%m-%dT%H_%M_%S);
CONFIG_FILE=/root/db-config.cnf

function contains() {
 local n=$#
 local value=${!n}
 for ((i=1;i &lt; $#;i++)) {
 if [ "${!i}" == "${value}" ]; then
 echo "y"
 return 0
 fi
 }
 echo "n"
 return 1
}


test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"
# Get the database list, exclude information_schema
database_count=0
tbl_count=0

for db in $(mysql --defaults-extra-file=$CONFIG_FILE -B -s -u $user -e 'show databases' )
do
 if [ $(contains "${leave_dbs[@]}" "$db") == "y" ]; then
 echo "leave database $db as requested"
 else

 # dump each database in a separate file
 (( database_count++ ))
 DIR=$BACKUP_DIR/$db
 [ -n "$DIR" ] || DIR=.

 test -d $DIR || mkdir -p $DIR

 echo
 echo "Dumping tables into separate SQL command files for database '$db' into dir=$DIR"

 for t in $(mysql --defaults-extra-file=$CONFIG_FILE -NBA -h $host -u $user -D $db -e 'show tables')
 do
 if [ $(contains "${leave_tables[@]}" "$db.$t") == "y" ]; then
 echo "leave table $db.$t as requested"
 else
 echo "DUMPING TABLE: $db.$t"
 # mysqldump --defaults-extra-file=$CONFIG_FILE -h $host -u $user $db $t &gt; $DIR/$db.$t.sql
 tbl_count=$(( tbl_count + 1 ))
 fi
 done

 echo "Database $db is finished"
 echo '----------------------------------------'

 fi
done
echo '----------------------------------------'
echo "Backup completed"
echo '**********************************************'
</code></pre>

And also, this helped:

<a href="https://stackoverflow.com/questions/3685970/check-if-a-bash-array-contains-a-value">Check if bash array contains value</a>

<a href="https://stackoverflow.com/questions/17232526/how-to-pass-an-array-argument-to-the-bash-script">arrays in bash</a>

<a href="https://unix.stackexchange.com/questions/129391/passing-named-arguments-to-shell-scripts/204927">named arguments in script</a>

I'd like to get dumps of each mysql table into separate files. The manual indicates that the syntax for this is 

<pre><code>mysqldump [options] db_name [tbl_name ...]
</code></pre>

Which indicates that you know the table names before hand. I could set up the script that knows each table name now, but say I add a new table down the road and forget to update the dump script. Then I'm missing dumps for one or more table. 

Is there a way to automagically dump each existing table into a separate file? Or am I going to have to do some script-fu; query the database, get all the table names, and dump them by name.

If I go the script-fu route, what scripting langauges can access a mysql database?

dump all mysql tables into separate files automagically?

数据库

服务器

MySQL

我想把每个mysql表的转储文件放到单独的文件中。该手册指出，此操作的语法为mysqldump [options] db_name [tbl_name ...]这表明您事先就知道表的名称。我现在可以设置一个知道每个表名的脚本，但是假设我添加了一个新表，却忘记了更新转储脚本。那么我缺少一个或多个表的转储。有没有一种方法可...

问自动将所有mysql表转储到单独的文件中？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问自动将所有mysql表转储到单独的文件中？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问自动将所有mysql表转储到单独的文件中？
EN