Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 14, 2006, 2:15 pm
rate this thread
Server 2000. If I were using Microsoft SQL Server 2000, I would need
special software to back up an open SQL Server database. Does this same
problem exist with My SQL?
In otherwords, could I take the native NTbackup.exe that comes with
Server 2000 and back up an open MySQL database without stopping the
Re: Backing up MySQL database
It's going to exist with just about any database. Use mysqldump.
The problem is that the server may modify the files *while* you are
backing them up and it may have cached data in memory that hasn't
been written to disk yet. This gives you inconsistent data in the
Another issue is that the file format may change between versions.
Assuming that NTbackup.exe backs up a set of files, on an active
database that would not work reliably.
Gordon L. Burditt
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum