Welcome to WebmasterWorld Guest from 54.157.225.99

Forum Moderators: open

Message Too Old, No Replies

MySQL Databases

MySQL Databases

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

New User

joined:Aug 28, 2012
posts:22
votes: 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
8:50 am on Sept 14, 2012 (gmt 0)

Administrator

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

joined:Aug 10, 2004
posts:10596
votes: 22


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]
9:19 am on Sept 14, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 17, 2002
posts:1187
votes: 6


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.
10:08 am on Sept 14, 2012 (gmt 0)

Administrator

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

joined:Aug 10, 2004
posts:10596
votes: 22


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)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members