This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › MySQL database backup and export
View: 35346|Reply: 3

[Source] MySQL database backup and export

[Copy link]
Posted on 8/24/2017 10:02:00 AM | | | |
mysql actually comes with its own database backup and export tools, which are located under the bin directory of the mysql installation directory

mysqldump is a client-side logical backup tool that can generate a SQL statement that reproduces the original database and tables, supports all storage engines, and supports hot standby for InnoDB

Basic syntax format




If my database is itsvse, the command to back up the database is as follows:

mysqldump exports database "access denied"
http://www.itsvse.com/thread-4005-1-1.html
(Source: Architect)






Previous:The official version of Xshell is implanted with a backdoor Trojan
Next:mysqldump exports database "access denied"

Related Posts
 Landlord| Posted on 3/27/2018 2:09:36 PM |
mysqldump -uroot -p123456 --no-data --databases itsvsedb > itsvsedb.sql

Only the table structure is exported, no data is included
 Landlord| Posted on 1/24/2021 2:42:13 PM |
Back up data and table structures

 Landlord| Posted on 9/30/2021 1:04:06 PM |
Backing up data from remote databases:


Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com