On 2007.06.12. 11:27, Mostafa Itani wrote: > Dear All, > > I am running bacula version “2.0.2” on Linux Redhat enterprise 4. The > server is running moodle application. Basically a web application with > MYSQL database. > > I want to make sure that the back up of MYSQL is done even when the > database is being accessed. Meaning when users are modifying the > database, and the backup is running at the same time, I just want to > make sure about the result, and how bacula will handle this. As I read > it takes a shadow or snapshot, backs it up and then delete the image, I > just want a confirmation message, that the database will not be skipped > during the back up.
there are several ways to accomplish this. 1. if all (or most) of your tables are innodb, the best probably is to use mysqldump and dump databases in a single transaction. a) you can dump the data to files, which later get backed up by bacula; b) you can take db backup through a pipe 2. you can also place your db on lvm, and backup script can lock all tables for writing, take a volume snapshot, unlock tables and then back up the snapshot. could be less reliable for complex systems. > Best regards, > ---------------------------------------------------------------------------- > Mostafa Itani > > System Administrator > > American University of Beirut > College Hall B2 > > P.O. Box 11-0236 Beirut, Lebanon > > Tel: +961 1 350000 - Ext: 3518 > > Cell: +961 3 811972 > > Web: www.aub.edu.lb <http://www.aub.edu.lb> -- Rich ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
