Re: Database backups initiated from Tomcat

2004-05-20 Thread Frank Burns
Thanks to ALL who contributed to helping me with this! - Original Message - From: "Tom K" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 9:54 PM Subject: RE: Database backups initiated from Tomcat

RE: Database backups initiated from Tomcat

2004-05-19 Thread Tom K
Original Message- From: Ben Souther [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:37 PM To: Tomcat Users List Subject: Re: Database backups initiated from Tomcat On Wednesday 19 May 2004 04:22 pm, Tom K wrote: > I'm not sure either, but you could try it in a sync

RE: Database backups initiated from Tomcat

2004-05-19 Thread Tom K
http://www.opensymphony.com/quartz/ you can set it up to schedule jobs at any time, recurring and likewise. Tom Kochanowicz -Original Message- From: Ben Souther [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:28 AM To: Tomcat Users List Subject: Re: Database backups initiated from Tomcat I&

Re: Database backups initiated from Tomcat

2004-05-19 Thread Ben Souther
On Wednesday 19 May 2004 04:22 pm, Tom K wrote: > I'm not sure either, but you could try it in a sync block and see if it > works and let us know ;-) Yoav Shapira answered that. (getRuntime().exec is non-blocking) Read his reply for the details. ---

Re: Database backups initiated from Tomcat

2004-05-19 Thread Iván Rodríguez
st" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 4:28 PM Subject: Re: Database backups initiated from Tomcat I'm not sure if getRuntime().exec(String cmdline) is synchronous or not. Also I don't know if mySql makes any provisions for locking a table during a dump. Those are

RE: Database backups initiated from Tomcat

2004-05-19 Thread Shapira, Yoav
Hi, Oooh, it's been a while since someone raised an exec() solution on the ilst, so it's worth bringing up a few points ;) >I'm not sure if getRuntime().exec(String cmdline) is synchronous or not. It's a non-blocking call. What you get back is a java.lang.Process object. You can read from this

Re: Database backups initiated from Tomcat

2004-05-19 Thread Ben Souther
I'm not sure if getRuntime().exec(String cmdline) is synchronous or not. Also I don't know if mySql makes any provisions for locking a table during a dump. Those are the questions I would want answered before going ahead. On Wednesday 19 May 2004 10:15 am, Frank Burns wrote: > So you think run

Re: Database backups initiated from Tomcat

2004-05-19 Thread Frank Burns
quot; in taking this route. Frank. - Original Message - From: "Tom K" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 2:45 PM Subject: RE: Database backups initiated from Tomcat > What operating sy

Re: Database backups initiated from Tomcat

2004-05-19 Thread Frank Burns
Thanks Doug. - Original Message - From: "Parsons Technical Services" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 2:31 PM Subject: Re: Database backups initiated from Tomcat > Frank, > > Not havin

Re: Database backups initiated from Tomcat

2004-05-19 Thread Frank Burns
ROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 2:52 PM Subject: Re: Database backups initiated from Tomcat > On Wed, May 19, 2004 at 02:04:33PM +0100, Frank Burns wrote: > : I have an urgent requirement where I have to initiate a

Re: Database backups initiated from Tomcat

2004-05-19 Thread QM
On Wed, May 19, 2004 at 02:04:33PM +0100, Frank Burns wrote: : I have an urgent requirement where I have to initiate a database backup (of : three mySQL tables) prior to performing an upload and update of the : database. How is the update/upload being done? commandline/mysql session, within the se

RE: Database backups initiated from Tomcat

2004-05-19 Thread Tom K
: Frank Burns [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 8:05 AM To: Tomcat Users List Subject: Database backups initiated from Tomcat Hi, I have an urgent requirement where I have to initiate a database backup (of three mySQL tables) prior to performing an upload and update of the

Re: Database backups initiated from Tomcat

2004-05-19 Thread Parsons Technical Services
be of more help on item 2. Doug www.parsonstechnical.com - Original Message - From: "Frank Burns" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 9:04 AM Subject: Database backups initiated from Tomcat &

Database backups initiated from Tomcat

2004-05-19 Thread Frank Burns
Hi, I have an urgent requirement where I have to initiate a database backup (of three mySQL tables) prior to performing an upload and update of the database. The preferred method of backing up is to use the mysqldump script. Can anyone: 1) tell me whether this is possible -- i.e., running the m