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

-------------------------------------------------------------------------
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

Reply via email to