On 9/2/05, Philipp Steinkrueger <[EMAIL PROTECTED]> wrote: > Hi, > > > 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. >
stop tha database and then copy all database files or schedule mysqldump --all-databases to run daily (or as often as you want...) The dump is very fast and will not require downtime. Reagrds, Umberto > i dont want to dump the mysql-dbs before the backup, because this would > take days... > > so, do i risk corrupted mysql-dbs or do i just risk to miss a query ? > > > best regards, > 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 > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------- 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 Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
