Hello,
Dmitry S. Vlasov wrote:
Hello!
Can anyone tell me right solution for backup MySQL databases (MyISAM and
InnoDB) without slave server ( i mean without any replication) and
without stopping service?
How I feel, backup binary files on-the-fly is realy bad idea :)
There are different options, and which one is best for you depends on
your needs.
- You could use a run before script that stops the databse and a run
after script to start it again. This makes database access unpossible
during backup, obviously, and when using the same database server for
your backup that's not really an option.
- You could use a snapshop, but this doesn't guarantee a consistent
state of the database before backup, it only lowers the risk of the
database changing during backup and thus creating an inconsistent backup.
- Use mysqldump to dump the database(s) to a file or sucket you then
store. The options --lock-tables and --single-transaction could be useful
- mysqlhotcopy could also be used.
- Using any of the above, you could inform your applications that the
database is to be modified and they have to keep their fingers off it.
Arno
-------------------------------------------------------
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
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
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
