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" +--------------------+ How to do it: [root@fangfull-backup ~]# mysql -uroot -p -e "show databases"|grep -Ev "Database|information_schema|mysql|test|jkhw_db" 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. You may also be interested in:
|
<<: JavaScript Dom implements the principle and example of carousel
>>: Detailed explanation of configuring keepalived log to another path in centos7
1. What is scaffolding? 1. Vue CLI Vue CLI is a c...
Table of contents Overview 1. Function debounce 2...
If the words in the sql statement conflict with t...
【SQL】SQL paging query summary The need for paging...
The first step is to unzip the compressed package...
The main symptom of the conflict is that the FLASH...
Many of my friends may encounter a problem and do...
1. View the types of fields in the table describe...
1. Cleaning before installation rpm -qa | grep jd...
1. Elements and tags in HTML <br />An eleme...
chmod Command Syntax This is the correct syntax w...
<br />Previous article: Web Design Tutorial ...
In fact, it is very simple to achieve this effect,...
This article is mainly to take you to quickly und...
As a backend programmer, you deal with Linux in m...