Welcome to WebmasterWorld Guest from 54.163.52.98

Forum Moderators: open

Message Too Old, No Replies

MySQL Databases

MySQL Databases

     

AimyThomas

2:46 am on Sep 14, 2012 (gmt 0)



Hello all again,

How do you guys backup your MySQL databases?

I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the database and that's it?

Any recommend for the tool?

Thanks

phranque

8:50 am on Sep 14, 2012 (gmt 0)

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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

9:19 am on Sep 14, 2012 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

10:08 am on Sep 14, 2012 (gmt 0)

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month