I've always just used the mysqldump program which outputs all of the commands to create the tables and data. Output this to a file and you have a backup of your database. The MySQL reference manual has a good section on how to use this (Section 15.7 in my documentation).
Steve _____________________________________________________________ Steve Cousins Email: [EMAIL PROTECTED] Research Associate Phone: (207) 581-4302 Ocean Modeling Group School of Marine Sciences 208 Libby Hall University of Maine Orono, Maine 04469 On Thu, 4 Apr 2002, John Rosendahl wrote: > Does anyone know of a tryly slick way to back up mysql databases. > Right now I am trying to write a script which read-only locks the > databases > then runs amanda and then unlocks the data bases. I am having fun doing it > but I see little reason to re-invent the wheel if someone else has > already done this. > I also could be going about this in an entirly wrong headed manner. All > I know is > I will not have the diskspace to hold an entire mysql hotcopy on disk, > so I am > trying to find a way to have amanda back up the database files directly. > The > ultimate solution would be to have amanda go through and lock the databases > individualy as it works but that I fear is close to impossible. Oh well. > thanks in advance for any help > -john > > > >
