Friday, October 5, 2012

MYSQL Incremental Backup



Blogs by Others:
http://www.sqlpronews.com/2010/0511.html
http://mossiso.com/2012/07/24/backing-up-mysql-with-replication-and-incremental-files-part-1.html
http://clean-clouds.com/2012/03/22/1785/

Leading Authority on MYSQL backups:
http://www.xaprb.com/blog/?s=incremental+backup

Different Methods:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html

QUESTIONS TO ASK BEFORE ADOPTING A TECHNIQUE:
http://www.mysqlperformanceblog.com/2009/03/03/10-things-you-need-to-know-about-backup-solutions-for-mysql/

Questions on stackoverflow:
http://stackoverflow.com/questions/4411057/how-to-do-a-incremental-backup-in-mysql

Example Implementation:
http://standish.home3.org/mysql-backup

Cautions and Dangers:
http://www.mysqlperformanceblog.com/2009/05/14/why-mysqls-binlog-do-db-option-is-dangerous/

Commands:
http://linuxcommand.org/man_pages/mysqldump1.html
http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html

Must Knows:
http://dev.mysql.com/doc/refman/5.1/en/replication-rules.html
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html(3.5*)
http://dev.mysql.com/doc/refman/5.1/en/point-in-time-recovery.html(4*)


NOT SURE:
PHP: http://erlycoder.com/109/php-mysql-incremental-backup-restore-implementation-download-the-script-

PRODUCTS:
FREE:
1.http://www.zmanda.com/backup-mysql.html
usage:http://freelinuxtutorials.com/tutorials/full-incremental-mysql-backup-via-mysql-zrm/

PAID:
1.http://www.mysql.com/products/enterprise/backup.html



No comments:

Post a Comment