> -----Original Message-----
> From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]]
> Sent: 3. september 2002 11:59
> To: [EMAIL PROTECTED]
> Subject: MySQL Backup
>
>
> Hi, can someone point me in the right direction please
> regarding backing up
> a MySQL database using Veritas 8.6 on a Windows 2000 server?
>
> Is there a script I can use to dump the database to a cold
> file where I can
> back it up off-line or are there agents available to enable
> me to back the
> database up live.
>
I usually just copy the complete DB directory from one computer to another
one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have
to backup the table where I store images). Only thing is that mysql can't
write to the table currently being copied. But that's not much of a problem,
since I do the copy in the wee hours of the night, when almost no one uses
the server.
Is this a 'stupid' thing to do?
I've done this for some time and nothing has gone wrong, no data corrupted
either. Running source compiled 4.0.2-alpha:
Uptime: 70 days 6 hours 42 min 24 sec
Threads: 11 Questions: 215514424 Slow queries: 613 Opens: 87 Flush
tables: 1 Open tables: 59 Queries per second avg: 35.492
Erlend Stromsvik
---------------------------------------------------------------------
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
