[Mediawiki-l] Database backup, How to

[Arthur Guy]

To backup my database server (Win 2000) I have created a batch file with the mysqldump dos command in, task scheduler then runs this script 4 times a day and my backup software takes the .sql dump file and moves it of site.
I use this setup for several tables and the while system works very reliably.

Arthur
arthur at astarsolutions.co.uk
-----Original Message-----
From: mediawiki-l-bounces at Wikimedia.org [mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Vasiliadis, Thomas
Sent: 25 January 2006 11:36
To: MediaWiki announcements and site admin list
Subject: AW: [Mediawiki-l] Database backup, How to

A Windows Server 2003 

-----Ursprüngliche Nachricht-----
Von: mediawiki-l-bounces at Wikimedia.org [mailto:mediawiki-l-bounces at Wikimedia.org] Im Auftrag von Rob Church
Gesendet: Donnerstag, 19. Januar 2006 13:31
An: MediaWiki announcements and site admin list
Betreff: Re: [Mediawiki-l] Database backup, How to

Are you using a Unix-like operating system, such as Linux, or a
Windows-based machine, or a Mac?


Rob Church

On 19/01/06, Vasiliadis, Thomas <T.Vasiliadis at schlemmerblock.de> wrote:
> Thank you, but how do I do a cronjob?
>
> -----Ursprüngliche Nachricht-----
> Von: mediawiki-l-bounces at Wikimedia.org [mailto:mediawiki-l-bounces at Wikimedia.org] Im Auftrag von Schmidt, Torsten
> Gesendet: Donnerstag, 19. Januar 2006 10:31
> An: MediaWiki announcements and site admin list
> Betreff: AW: [Mediawiki-l] Database backup, How to
>
> i do my Backups with the following script as a cronjob:
>
> -----------
> DATE=`date +%d-%m-%Y_%H-Uhr-%M`;
>
> mysqldump -uroot -pSECRET --default-character-set=latin1 --opt wikidb > /path/to/backup/wikidb_$DATE.sql
>
> # Wiki-htdocs
> rsync -a /usr/local/www/mediawiki/ /path/to/htdocs/backup
> -----------
>
>
> -----Ursprüngliche Nachricht-----
> Von: mediawiki-l-bounces at Wikimedia.org
> [mailto:mediawiki-l-bounces at Wikimedia.org]Im Auftrag von Vasiliadis,
> Thomas
> Gesendet: Donnerstag, 19. Januar 2006 10:00
> An: MediaWiki announcements and site admin list
> Betreff: [Mediawiki-l] Database backup, How to
>
>
>
> Hi there,
>
> I have succesfully installed a Wiki with MySQL 5.0.15-nt and now I have
> to manage the Backups.
> But how to do it?
> I found a Directory named mysql\data\wikidb with some MYI MYD and FRM
> files. Is it this, what I have to Backup?
> Is there any methode of do it automatical?
> I have installed it via xampp
>
> Thanks
>
> TV
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l