Hello! Erlend Hopsø Strømsvik wrote:
> > >>-----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. > > If you are copying the data from one computer to the other, why not installing a little mysql on the backup machine and replicate to that mysql? With only inserts/deletes/updates done on the replication machine, there is no high load to be expected and you have an up-to-date copy all the time. >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 > > > > Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de --------------------------------------------------------------------- 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