问题原文
原帖链接 · Christian · CC BY-SA 3.0
I'm trying to figure out how to exclude or include specific tables when doing mysqldump command on AWS via terminal.
Background: I have a WordPress multisite but only need the tables with the first 3 characters "wp_" all of the other tables with prefixes like "wp_1", "wp_2", etc. I don't need in the dump file.
Here is the code I am using to generate the dump file which works but grabs all the tables in the database:
mysqldump -h RDS instance endpoint \
-u user \
-p databasename \
--port=3306 \
--single-transaction \
--routines \
--triggers \
--databases databasename > path/rds-dump.sql
Thanks!
已采纳解答
原帖链接 · Sunny · CC BY-SA 3.0
One thing that I have implemented when I faced same issue is that I created a file with all the required table names. Now I just have to Iterate through the file and take the dump of each table and append it in the same dump file. For example:
for i in $(cat requiredtables.txt);do mysqldump -h RDS_instance -u user -p'password' db_name $i >> db_dump.sql;done
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
