Dan Langille wrote:
On 2 Sep 2005 at 14:16, Philipp Steinkrueger wrote:
Dan Langille wrote:
On 2 Sep 2005 at 12:39, Philipp Steinkrueger wrote:
if i want to backup a server running a mysql-db and i just backup
all the mysql-db-files, do i risk to save a corrupted version? i read
in the manual about the VSS problematic and save state in RDBMS
on windows, but in my case, the mysql db runs on linux.
i dont want to dump the mysql-dbs before the backup, because this would
take days...
How large is your database?
well, actually its more than one database. its a lamp system running
dozens of databases.
dumping them all would really eat up a lot of time...
How much time? I ask because it sounds like you are assuming and
have not actually tried it.
My usual stance is: What is more important to you? a fast backup or
a reliable backup?
you are right, i have not actually tried it with this database server,
but i have experience with
other projects running on even faster servers. the server i need to
backup now is always under
heavy load and dumping would take a long time. even if it would be
sitting around lazy it would
take time to write several GB (around 6 at the moment) of data to disk...
greetings,
philipp
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
