Automated MySQL backup programs?

[Jesus Pimp]

Can anyone recommend a free automated server side program that you can schedule a weekly backup of the MySQL database and save it to the server or email?

[hrdwareguy]

What operating system are you using?

[Jesus Pimp]

WinXP and OS X. I need a program that is server side not a local program.

[asshopo]

WinXP, have a scheduled task run a VBS file, and do something like:

exestring = "c:\mysql\bin\mysqldump.exe --all-databases -u <YOURUSERNAMEHERE> --password=<YOURPWDHERE> -r E:\Backup\MySQL\mysql-backup_" & GetDate() & ".sql"
ExecuteString exestring 

'''''''''''''''''''''''''''''''''''''''''''''''''''
'ExecuteString: Runs passed string in command shell
'''''''''''''''''''''''''''''''''''''''''''''''''''
public sub ExecuteString(exestring)
	set app = WScript.CreateObject("WScript.Shell")

	'WriteDebug ".\debug.txt", exestring 
	'app.popup exestring

	app.run exestring, 1, true
end sub
''''''''''''''''''''''''''''''''''''''''''''''
'/end
''''''''''''''''''''''''''''''''''''''''''''''

''''''''''''''''''''''''''''''''''''''''''''''
'Debug: Write passed info to file
''''''''''''''''''''''''''''''''''''''''''''''
public sub WriteDebug(lstrFile, lstrTxt)
	Const ForReading = 1, ForWriting = 2
	Dim fso, f
	Set fso = CreateObject("Scripting.FileSystemObject")
	Set f = fso.OpenTextFile(lstrFile, ForWriting, true)
	f.WriteLine lstrTxt
end sub
''''''''''''''''''''''''''''''''''''''''''''''
'/end
''''''''''''''''''''''''''''''''''''''''''''''

'''''''''''''''''''''''''''''''''''''''''''''''
'GetDate: Returns the date in yyyy/mm/dd format
'''''''''''''''''''''''''''''''''''''''''''''''
public function GetDate()
	'Get the date
	thedate = datepart("yyyy", now)

	'Fill in single month digits with a 0
	If len(datepart("m", now)) = 1 Then
		thedate = thedate & "0" & datepart("m", now)
	else
		thedate = thedate & datepart("m", now)
	End if
	
	'Fill in single date digits with a 0
	If len(datepart("d", now)) = 1 Then
		thedate = thedate & "0" & datepart("d", now)
	else
		thedate = thedate & datepart("d", now)
	End if

	GetDate = thedate
end function 
''''''''''''''''''''''''''''''''''''''''''''''
'/end
''''''''''''''''''''''''''''''''''''''''''''''

Replace --all-databases with databases <DATABASE1> <DATABASE2> 3,4,5,etc.

I have one for unix (osx, whatever, as long as it supports cron)... Ill see if I can find it, but its similar.. the mysqldump <OPTIONS HERE> is the same, but getting the date is a little different (easier).

[asshopo]

Something like (call this file backup.sh):

#!/bin/bash

#Get current date
TODAY=$(date +%Y%m%d)

mysqldump --all-databases -u <YOURUSERNAMEHERE> --password=<YOURPWDHERE> -r /path/to/backup/directory/mysql-backup_$TODAY.sql

exit 0

And then enter a cron entry like:

00 1 * * * <YOURSYSTEMUSERNAMEHERE> /path/to/backup.sh

To run the script at 1am, everyday.

[ratbastid]

If the OSX MySQL distro is anything like the Linux/FreeBSD distro, you've got a great program called mysqldump that creates SQL output from a MySQL database. Set that up to run as a cron job, and you're set.

OSX has cron, right??