Re: rsync and mysql with users connected

2006-06-23 Thread JamesDR
ast do as much as can be done. Windows likes to go part way in a random order and the die at the first sign of trouble. -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *Grignon Mickaël *Sent:* Friday, June 23, 2006 11:02 AM *To

RE: rsync and mysql with users connected

2006-06-23 Thread Tony Abernethy
o as much as can be done. Windows likes to go part way in a random order and the die at the first sign of trouble.   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Grignon MickaëlSent: Friday, June 23, 2006 11:02 AMTo: rsyncSubject: rsync and m

Re: rsync and mysql with users connected

2006-06-23 Thread Maarten Boot (CWEU-USERS/CWNL)
Mickaël, In general one should not backup databases while they are running. the safest way to backup any database is to switch it off (usually called coldmode) and to run in your case rsync. another way is th run the normal mysql backup commands to a local disk location and after the mysql ba

rsync and mysql with users connected

2006-06-23 Thread Grignon Mickaël
Hi,   I want to apologise for my bad english (I'm french).   So I need to Back-up a lot of datas from a place to an another by the way of rsync with ssh naturally.   A good question from my boss was : What happened when the mysql database is used by a user during the Backup ? Is the system