Scheduled Automatic Backup

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Scheduled Automatic Backup

Postby Hetfield » 25. March 2009 02:44

Hi,

I'm wanting to set a scheduled automatic backup, to backup the xampp directory and it's databases. What is the best way to do this? I know you can export from phpmyadmin but that is a manual process, and I need something I can set and let it do it's thing without me having to do anything.

Thanks in advance
Hetfield
 
Posts: 3
Joined: 25. March 2009 02:41

Re: Scheduled Automatic Backup

Postby Izzy » 25. March 2009 02:49

Which version of Windows?
Which version of XAMPP?
Both omitted.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Scheduled Automatic Backup

Postby Hetfield » 10. May 2010 01:40

Hi,

I have it installed on Windows Server 2000 SP4, and it's version 1.7.0 of Xampp.

Thanks.
Hetfield
 
Posts: 3
Joined: 25. March 2009 02:41

Re: Scheduled Automatic Backup

Postby JonB » 10. May 2010 02:50

Here's one that will solve 1/2 the problem...

http://realm3.com/articles/how_to_sched ... in_windows

8)

Somewhere I have my own script that works with any MySQL database date and timestamps the backup. Its a bit differnet, but the concept is the same. It must be on one of my 'work' machines. Grrrrrrr....

:mrgreen:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Scheduled Automatic Backup

Postby nicoleta » 11. May 2010 20:46

I have a MediaWiki site that would be great to make automatic backups of with XAMPP for Windows 1.7.2 running on Windows Vista Ultimate 64-bit.
On Command Prompt, how do I go from C:\Users\Nicole> to C:\xampp\mysql\bin\mysqldump ?
Is " at 02:00 /every:M,T,W,Th,F,S,Su c:\<path>\mysql-backup.bat " once a week or every day?
I'm not familiar with Command Prompt, sorry :-(.
nicoleta
 
Posts: 9
Joined: 09. May 2010 08:19
Location: Maryland, USA

Re: Scheduled Automatic Backup

Postby Hetfield » 18. May 2010 05:04

Perfect JonB. That website was extremely helpful and now I have a daily backup that dumps the db to a file which I store on another PC, which is also backed up!

Thanks.
Hetfield
 
Posts: 3
Joined: 25. March 2009 02:41

Re: Scheduled Automatic Backup

Postby JonB » 18. May 2010 05:14

That's great! Glad it worked out for you.

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Scheduled Automatic Backup

Postby JonB » 18. May 2010 05:24

Nicoleta:

use the cd command (change directory)

cd C:\xampp\mysql\bin\

if you want see what's there type 'dir' (directory)

'mysqldump' is the program name for mysqldump.exe, its part of the standard MySQL distribution.

The instructions on that site are quite accurate as long as you are working in English, as the date command is language localized.

:idea:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests