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]
