phranque
msg:4495096 | 8:50 am on Sep 14, 2012 (gmt 0) |
if you can open a terminal with a command line or run a shell script i would use mysqldump — A Database Backup Program:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html [dev.mysql.com]
|
Frank_Rizzo
msg:4495114 | 9:19 am on Sep 14, 2012 (gmt 0) |
Control panels / apps such as Webmin are good for automating these tasks.
The quickest way though is to shut down mysql and just tar and gzip the mysql directory structure then start mysql again. Obviously that may not be practical in some situations but it is good in others.
Don't forget to test that the backups work. Make sure you have a procedure for restoring the data.
|
phranque
msg:4495130 | 10:08 am on Sep 14, 2012 (gmt 0) |
if you are going to back up the raw database files i would strongly recommend you also keep a backup of the corresponding database dump. (in sql)
and as mention by Frank_Rizzo, testing your backups is critical.
also note there may be files and directories containing content outside of the database that should be part of your backup plan. (images, scripts, etc)
|
|
