How to filter out certain libraries during mysql full backup

Use the --all-database parameter when performing a full backup of MySQL

for example:

#mysqldump -u root -h localhost -p --all-database > /root/all.sql

When importing data, you can first log in to the MySQL database and use source /root/all.sql to import.

question:

I want to filter out certain libraries when backing up the database with mysqldump.

In this case, you cannot use --all-database when backing up mysqldump, but use --database instead .

As follows: When backing up the database , filter out the information_schema, mysql, test, and jkhw_db libraries

[root@fangfull-backup ~]# mysql -uroot -p -e "show databases"
Enter password:

+--------------------+
| Database |
+--------------------+
| information_schema |
|hqsb_db|
| jkhw_db |
|mysql |
| test |
| tech_db |
|hqtime_o2o_db|
|hq_o2o_db|
| hqtime_o2o_db_new |
+--------------------+
9 rows in set (0.00 sec)

How to do it:

[root@fangfull-backup ~]# mysql -uroot -p -e "show databases"|grep -Ev "Database|information_schema|mysql|test|jkhw_db"
Enter password:
hqsb_db
tech_db
hqtime_o2o_db
hq_o2o_db
hqtime_o2o_db_new
[root@fangfull-backup ~]# mysql -uroot -p -e "show databases"|grep -Ev "Database|information_schema|mysql|test|jkhw_db"|xargs
Enter password:
hqsb_db tech_db hqtime_o2o_db hq_o2o_db hqtime_o2o_db_new
[root@fangfull-backup ~]# mysql -uroot -p -e "show databases"|grep -Ev "Database|information_schema|mysql|test|jkhw_db"|xargs mysqldump -uroot -p --databases > mysql_dump.sql
Enter password:

The above method of filtering out certain libraries during a complete MySQL backup is all I have to share with you. I hope it can give you a reference, and I also hope that you will support 123WORDPRESS.COM.