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 servlet itself, etc? You could put the backup at the head of that
procedure.


: 1) tell me whether this is possible -- i.e., running the mysqldump script
: from a servlet

The one way that comes to mind is Runtime.exec(), but that may cause
memory issues since (under Unix-like OSs) it calls fork(). If the
container has been allocated a lot of memory, well...


: 2) give me any clues/details on the best way to do this?

If this *must* be done within a servlet, I don't see many options other
than Runtime.exec()...

-QM

ps- please create a new message when posting to the list. Replying to
an old (unrelated) message causes hell on thread-aware mailers, even if
you change the subject. Thanks.


--

software -- http://www.brandxdev.net
tech news -- http://www.RoarNetworX.com


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)