Forums & Blog

I  have been tasked with finding a way to do a clean backup of the mysql db  and related data on our Smarterticket system.  We are looking for the best way to do a hot copy of the db.

Look into using SQLyog or PHPAdmin.  Both work well and are Windows based.  You can schedule backups or run them on-demand.

TR

AH - ok.  Well I use Symantec Backup Exec 11D with the IDR and SQL agent.  THis has worked great for me.  This backs up the DB, Server and if there is a sever failure, I can realoed the entire server and SQL database with one tape and one CD (created with the IDR option).  If you can;t afford that route, then write a script that stops the SQL services, copies and zips up the MDF and LDF files pertaining to your database, and then start the SQL services back up.  This is a reall easy, no frills apprach and if you have times of relative quite time on the database this is super easy to do.  Then you can just burn these off to CD/DVD and you need to.

TR