homepage Welcome to WebmasterWorld Guest from 54.166.100.8
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MySQL Databases
MySQL Databases
AimyThomas




msg:4494979
 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




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)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved