'C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe' -uRootUserName -pRootPassword -hlocalhost -all-databases > 'C:\MySQLBackup\MySQL_DB_Dump_all-databases. There are 2 sections, user at the top, and system below. Near the bottom, click the Environment Variables button. In the resulting dialog, click the Advanced tab. In the resulting window, choose Advanced System Settings in the sidebar. Rem the parameter '2>nul' below suppresses the information message from mysqldump informing about insecure passwords in CMD files. To do this, in Windows Explorer: Right-click Computer and select Properties from the menu. If exist 'C:\Datatrack\MySQL\Backup\MySQL_DB_Dump_all-databases.sql' del /f /q 'C:\Datatrack\MySQL\Backup\MySQL_DB_Dump_all-databases.sql' MySQL Community Edition is a freely downloadable version of the worlds most popular open source database that is supported by an active community of open source developers and enthusiasts. Rem Delete old (previous) dump and make a clean/new one If not exist 'C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe' goto error Rem Check if mysqldump.exe program is here Please test it intensively before going productive with it: offĮcho C:\MySQLBackup\MySQL_DB_Dump_all-databases.sql. Please note that we do NOT take any responsibility for the code. It's quite simple and does some basic error testing as well. You can use the following CMD file for this.
