MySQL Database Backup Script (With Compression)

[Akkadius]

I had the need to create this script to support compression and be flexible in times in which I would need it. It is pretty awesome and supports compression using 7-Zip and WinRar.

Look here for full info:

http://wiki.eqemulator.org/p?MySQL_DB_Backup_Script

What It Does

Specify specific database tables (Default will backup all) Example: tables="table1,table2,table3"
Specify a specific database (Default will use the database specified in the eqemu_config.xml) Example: database="dbname"
Specify a specific location for the Backup to go to (Default will go in the server folder, or wherever you run the script) Example: location="C:\Backups"
Specify compression, which will use 7-Zip or RAR to compress (If they are installed) Example: compress
​7-Zip Install (Recommended Highest Compression) - http://www.7-zip.org/download.html


Arguments

C:\Server>perl DB_Dumper.pl
ERROR! Need arguments
################################################## ####
loc="C:\File Location" - File path location to backup...
database="dbname" - Manually specify databasename, default is database in eqemu_config.xml
tables="table1,table2,table3" - Manually specify tables, default is to dump all tables from database
compress - Compress Database with 7-ZIP, will fallback to WinRAR depending on what is installed (Must be installed to default program dir)...
Example: perl DB_Dumper.pl loc="E:\Backups"
################################################## ####

Enjoy!