MSSQL and MySQL Backup Software

L

Landmine

Limp Gawd
Joined
Oct 19, 2011
Messages
402
Can anyone recommend an application that backups up MS SQL and MySQL from the local machine or remotely. MSDE would be a bonus as well.

Thanks HF!
 
Ever tried MySQL Workbench?
http://www.mysql.com/products/workbench/

There's an option to export your databases to a self-contained file:

2013-01-22_10-43-47.png


That's how it looks like on my home webserver.

That's for MySQL. For the others you mentioned, I'll have to look for that.
 
for mysql, if you need it automated, you can setup a cron/task to dump the database to a file whenever you need it...I had backups nightly from this

mysqldump -u USER -p PASSWORD DATABASE > DB_FILE.SQL

this should work on both linux and windows
 
For MSSQL is there a reason you don't want to use a maintenance plan for backups? You might look at Ola Hallengren's scripts for SQL or if you want GUI something like Redgate.
 
Some of the older versions or limited versions dont have that option available.
 
You must log in or register to reply here.
Back
Top