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 having done this myself (yet), There are a few options that come to > mind. > > 1. Set up a backup database (unless you plan to store it in the same one). > Read the metadata for the table you wish to copy, create a backup table, and > then do a select * and write the result set into the new table. > > 2. Call the script from a servlet. Sorry it has been a while since I have > done a call and thus don't remember the syntax. > > 3. If all you need is to preserve a copy that will not be accessed, then you > could block access to the table and do a file copy of the table. > > Sorry that I could not 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 > > > > 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 mysqldump script > > from a servlet > > > > 2) give me any clues/details on the best way to do this? > > > > Thanks, > > > > Frank. > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
