Re: Using dump on running databases
2003-04-15 14:53:22
On Tuesday 15 April 2003 12:42 pm, Chad Morland wrote:
> I was wondering if it is safe to do a filesystem dump using the dump
> command on running databases such as postfix and mysql? Thanks.
>
> -CM
I believe the proper thing to do is to use mysqldump or the equivalent, and
then backup the dumped database file. If you backup a live database, you may
end up with inconsistencies after a restore.
--
----------------------------------------------------------------
|Christopher Dahn | Software Engineering Research Group,|
|3141 Chestnut St. | Feel the SERG! |
|Attn: CS Dept., CAT 186 | http://serg.cs.drexel.edu/ |
|Philadephia, PA 19104 ------------------------------ ------
|Office (PA): 215.895.0203 | OpenPGP public key: |
|Office (NJ): 856.614.5430 | http://search.keyserver.net/ |
|Fax: 215.895.0545 | |
---------------------------------------------------------
|
|
|