On 2/20/2011 5:26 AM, Manolo Padron Martinez wrote:
> Hi:
>
> I would like to know what its the better way to make a copy from an
> apache+mysql+php webserver.
>
> I've been thinking about it and probably the best solution its to stop
> al services before to make the copy, but I'm looking for a way to do
> it without stop the service. Any idea?
>
> Regards from Canary Islands
>
Hello Canary!

The best way to do it is to dump the mysql database periodically (I do 
it nightly) and
let the scheduled backups pick up the dump (put it in a directory that 
gets backed up).
This way you don't need to interrupt anything and the database is 
portable to different
versions should you need to restore from a crashed system (and the 
current version is
upgraded). I also do this with the bacula database on the Director even 
though it gets
backed up by bacula, like this:

30 0 * * * /usr/bin/mysqldump bacula > 
/usr/src/scripts/bacula.dump.mysql > /dev/null 2>&1

Of course you need to add the appropriate entries in ~/.my.cnf, mine 
looks like this:

# more .my.cnf
[client]
user = root
password = SsEeCcRrEeTtPw
host = localhost

[mysql]
database = mysql

Regards,
Randy


------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users