@echo
off
set errorlevel = 0
set path_home_mysql = " I:JAVAMySQLMySQL Server 5.0"
set path_bin_mysql=%path_home_mysql%bin
set opt_mysql=--add-drop-database --add-drop-table
set database_mysql=--databases active_rbac
set user_mysql=root
set password_mysql=root
set backup_dir=%path_home_mysql%db_backup
set backup_file=%backup_dir%mysql_backup_%date:~0,10%.tgz
dir %backup_dir% || echo make dir &mkdir %backup_dir%
IF EXIST %backup_file% ( del %backup_file% &echo %backup_file% is deleted)
echo backup mysql database:%database_mysql%
%path_bin_mysql%mysqldump -u%user_mysql% -p%password_mysql% %database_mysql% %opt_mysql% > %backup_file%
echo end backup
set errorlevel = 0
set path_home_mysql = " I:JAVAMySQLMySQL Server 5.0"
set path_bin_mysql=%path_home_mysql%bin
set opt_mysql=--add-drop-database --add-drop-table
set database_mysql=--databases active_rbac
set user_mysql=root
set password_mysql=root
set backup_dir=%path_home_mysql%db_backup
set backup_file=%backup_dir%mysql_backup_%date:~0,10%.tgz
dir %backup_dir% || echo make dir &mkdir %backup_dir%
IF EXIST %backup_file% ( del %backup_file% &echo %backup_file% is deleted)
echo backup mysql database:%database_mysql%
%path_bin_mysql%mysqldump -u%user_mysql% -p%password_mysql% %database_mysql% %opt_mysql% > %backup_file%
echo end backup