-----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 prevent not integrity corrupted.
- --
Jeronimo Zucco
LPIC-1 Linux Professional Institute Certified
Núcleo de Processamento de Dados
Universidade de Caxias do Sul
"May the Source be with you." - An unknown jedi programmer.
http://jczucco.blogspot.com
Philipp Steinkrueger wrote:
> 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 windows, but in my case, the mysql db runs on linux.
>>
>>
>>
>> You can't.
>>
> what do you mean, that i cannot ? I can copy the files perfectly on
> linux and
> i cant perfectly restore them. the question is what the risk it...
>
>
> 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
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFDGEGhTCq0VJ4DIPwRAlAoAKDjgoQovmT2mONn4eEHWx78YJlJcgCdF80Z
tKYR1Ytfc4yFuqYJNfXl+Po=
=1aik
-----END PGP SIGNATURE-----
-------------------------------------------------------
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
