大网数据广告活动
服务器运维问答

Excluding/Including tables in mysqldump AWS

· 52CE 我爱测

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 o…

问题原文

原帖链接 · 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

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2016-02-19)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。