And another, this time to backup the databases, based on an earlier post or creating simple backups, I can then call this batch from within another batch file. @echo off IF %1.==. GOTO No1 ECHO Dave’s mySQL Database Backup UtilityECHO …
Tag Archives: MySQL
Backing up mySQL Databases Batch File / Script
Posted by dave on July 4, 2011
No comments
mySQL Restore Batch File / Script
Posted by dave on July 4, 2011
No comments
PHP optimisation in Windows IIS
Posted by dave on February 18, 2011
No comments
OSTicket Database Errors (Polish Characters)
Posted by dave on February 16, 2011
No comments
Speeding up MySQL Databases by setting the Query Cache Size
Posted by dave on February 11, 2011
No comments
Script to 7-zip all files and then delete the originals
Posted by dave on November 22, 2010
No comments
Restore a MySQL Database Backup from the .sql File
Posted by dave on May 11, 2010
No comments
Simple Script to backup MySQL Databases
Posted by dave on March 16, 2010
No comments
This is a simple script I use to backup MySQL databases. Save the following as backup.bat (or similar) and they you can set a scheduled task to run this daily. “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe” -uUSERNAME -pPASSWORD MYSQLDBNAME > “c:\folder\mysqldbname\mysqldbname_%time:~0,2%%time:~3,2%%time:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.sql” The …