Automated MySQL backup programs? - Tilted Forum Project Discussion Community

Jesus Pimp · 06-06-2005, 11:36 AM

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 · 06-06-2005, 02:50 PM

What operating system are you using?

Jesus Pimp · 06-06-2005, 06:00 PM

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

asshopo · 06-08-2005, 05:29 AM

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

Code:

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 · 06-08-2005, 05:40 AM

Something like (call this file backup.sh):

Code:

#!/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:

Code:

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

To run the script at 1am, everyday.

ratbastid · 06-08-2005, 06:43 AM

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??

06-06-2005, 11:36 AM	#1 (permalink)
Jesus Pimp The Original JizzSmacka	Automated MySQL backup programs? 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? __________________ Never date anyone who doesn't make your dick hard.

06-06-2005, 02:50 PM	#2 (permalink)
hrdwareguy "Officer, I was in fear for my life" Location: Oklahoma City	What operating system are you using? __________________ Gun Control is hitting what you aim at Aim for the TFP, Donate Today

06-06-2005, 06:00 PM	#3 (permalink)
Jesus Pimp The Original JizzSmacka	WinXP and OS X. I need a program that is server side not a local program. __________________ Never date anyone who doesn't make your dick hard.

06-08-2005, 05:40 AM	#5 (permalink)
asshopo Insane Location: Michigan	Something like (call this file backup.sh): Code: #!/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: Code: 00 1 * * * <YOURSYSTEMUSERNAMEHERE> /path/to/backup.sh To run the script at 1am, everyday. __________________ Patterns have a habit of repeating themselves.

06-08-2005, 06:43 AM	#6 (permalink)
ratbastid Darth Papa Location: Yonder	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??