Batch script sharing for one-click backup of MySQL database

This article mainly explains the "one-click backup MySQL database batch script sharing", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "one-click backup MySQL database batch script sharing" bar!

Save the following code as a .bat file

The code is as follows:

@ echo off echo. Echo MySQL database backup echo * * echo. Echo today is% date% echo time is% time% echo. Echo * * set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" md "D:\% Ymd%"C:\ Program Files\ MySQL\ MySQL Server 5.1\ bin\ mysqldump"-opt-Q-uroot-proot-- default-character-set=gbk mysql > "D:\% Ymd%\ mySQLteble.sql" echo. Echo MySQL database backup completed, please check. Echo. Echo. Pause thank you for your reading, the above is the content of "one-click backup MySQL database batch script sharing", after the study of this article, I believe you have a deeper understanding of the problem of one-click backup MySQL database batch script sharing, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!