On Monday 30 July 2007 Dimitrios's cat, walking on the keyboard, wrote: > What is the best way to backup MySQL databases? > > I've got a few web servers that i'd like to backup, which rely heavily on > MySQL for offering dynamic content. > > Should i just backup the "/var/lib/mysql/*" directly? Does that mean i have > to shutdown the MySQL process during the backup? (which means the web > server will be unable to offer content, web sites die) > > Any help would be appreciated
I'm not sure this is related to bacula. MySQL provides a tool, called mysqldump, that can be used to dump the data of a database and to rebuild it. I guess this is what you are looking for, even if there are other strategies (PITR, ...). Luca ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
