Mysql Dailybakup of all databases with same name one by one using script on windows
on January 12th, 2012 by Justin Jacob
MySQL backup of all database is done by mysqldump with –all-database,but using this method we can only backup all db to one sqldump file,here we use one script to backup all database with same name, @ECHO OFF SET BACKUPS_DIR=E:\mysqldailybackup SET MYSQL_DIR=D:\Program Files\MySQL\MySQL Server 5.0\bin SET USER=”root” SET PASSWORD=”root” SET PORT=”3306″ REM ============================ SET OLDDIR=%CD% [...]
