Hot database backups.

[jxfish2]

What's the best way to do a hot backup of the MySQL database?

Is there a way to do hot backups, using one of the freeware, shareware or GNU public release backup software applications?

I'm not worried about typical filesystem backups, but I have a small environment where I don't want to take the database down, in order to back it up...

Any suggestions would be greatly appreciated...

If possible, I'd like to find a GUI-based backup solution, to do the hot-backups...

TIA

JCF

 

[piti]

i have a cron job set, that creates a tar-gziped file of all my databases (tar -czf /home/backup/data/db_$y"_"$m"_"$d.tgz /home/data/mysql/, where $y, $m, $d are variables from my backup script)

i run it when the traffic on the server is almost null, so the data does not change and i do not need to stop the server

i'm sure there are better ways of doing this, but i like the speed of restoring the databases - just unpack that tgz to the datadir and that's it ;-)

 

[jxfish2]

I'm just concerned about taking a snapshot of the database, before all records / transactions have been written.

If that happens, you're going to corrupt the database, in the event of a restore...

JCF

 

[piti]

well i'm not
as tables are files, there is surely the unix way of accessing files applied, so i think you don't need to worry about corrupting it while packing it using tar