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...
so, do i risk corrupted mysql-dbs or do i just risk to miss a query ?
I *always* suggest dumping the database and going from there. If
this isn't an option, I suggest following up on the MySQL project
with suggestions.
allright, thanx,
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