Jan
12
Mysql Dailybakup of all databases with same name one by one using script on windows
Thursday, January 12th, 2012
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% [...]
