Re: [Bacula-users] Backup Mysql Database Files

2005-09-05 Thread Juergen Moellenhoff
http://sourceforge.net/projects/automysqlbackup/ 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

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Jonas Björklund
Hello, On Fri, 2 Sep 2005, 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

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
Hi, Jonas Björklund wrote: Hello, On Fri, 2 Sep 2005, 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

[Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
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. i dont want to dump the mysql-dbs

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
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?

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
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

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Umberto Nicoletti
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,

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Davide Bolcioni
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 believe

RE: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
On 2 Sep 2005 at 15:22, Heigl Florian - Munich-MR - e wrote: How much time? I ask because it sounds like you are assuming and have not actually tried it. [ I think in general it's not bad to think about things impact before trying :) ] Worthwhile. But one must also act with facts.

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Philipp Steinkrueger
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

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Jeronimo Zucco
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You only can copy the database files for mysql if table type is MyISAM. If you use innodb, only dump or using software InnoDB Hot Backup (it is not GPL). You can dump with lock database (is available only for queries in this time) for

Re: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Dan Langille
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

RE: [Bacula-users] Backup Mysql Database Files

2005-09-02 Thread Heigl Florian - Munich-MR - external
How much time? I ask because it sounds like you are assuming and have not actually tried it. [ I think in general it's not bad to think about things impact before trying :) ] My usual stance is: What is more important to you? a fast backup or a reliable backup? you are right, i