Tag Archives: Data backup

MySQL data backup scheme (compatible with local and remote)

For reprint, please indicate the source: http://blog.csdn.NET/itas109  

QQ technology exchange group: 129518033

 

This program will be updated continuously, and the software will be open source in the future…

 

At present, the solution:

1、 Execute CMD command, mysqldump and FTP by C + +

1. First of all, learn the syntax of mysqldump, which is not detailed here. For reference http://www.cnblogs.com/qq78292959/p/3637135.html

Export data (including remote) to local command

mysqldump -uroot -p123456 -h 192.168.1.101 databasetest > C:/data.sql

Pay attention to [seat according to the number]:

User name root

User name root

User name root

User name root

User name root

User name root

User name root

User name root Password 123456

Password 123456

User name root

User name root

User name root

User name root Password 123456

Password 123456 Local/remote IP 192.168.1.101 Database test
database test 2. C + + execute CMD command The above command is executed by anonymous pipeline, and the code will be open source later

2. C + + execute CMD command