Howdy,
I tend to do both a dump to disk and then stop the DB and do a tape backup.
I don't believe there is an "Online" backup capability as user transactions
would need to be stored and played back against the DB after the backup as
in most production ready DB's.
Sid Young
QML Pathology
Database Administrator
> -----Original Message-----
> From: Kraa de Simon [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 5:47 PM
> To: '[EMAIL PROTECTED]'
> Subject: Backup question
>
> Hi,
>
> I'm running MySQL on a NT box and do a nightly backup of the complete file
> system to tape.
>
> I know I should use mysqldump and probably stop MySQL but will a file
> system
> copy do as well? The system is inactive at the time.
>
> Met vriendelijke groet / With kind regards,
>
> ICL Nederland B.V. Simon de Kraa
> e-Applications / Logistic Systems Systems Architect
> Het Kwadrant 1 Tel. +31 346 598865
> Postbus 4000 Fax +31 346 562703
> 3600 KA MAARSSEN
> The Netherlands mailto:[EMAIL PROTECTED]
>
> ---
>
> Progress 9.1b, Roundtable 9.1c, NuSphere Pro Advantage 2.2 @ MS Windows
> 2000
> 5.00.2195 SP 2
> Progress 9.1b @ SCO UnixWare 7.1.1
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
