October 2007
WordPress Backups « WordPress Codex
Your WordPress database contains every post, every comment and every link you have on your blog. If your database gets erased or corrupted, you stand to lose everything you have written
September 2006
MySQL 5.0 Reference Manual :: 8.12 mysqldump — A Database Backup Program
For a faster "mysqldump" innodb tables 1. mysqldump --opt --user=username --password database > filetosaveto.sql 2. open the dump file put this statement at the beginning of the sql dump text file: SET FOREIGN_KEY_CHECKS=0; 3. mysql --user=usern
How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials
by 1 otherThis tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately repl
July 2006
ONLamp.com -- Live Backups of MySQL Using Replication
by 3 othersThere are only a few steps to setting up replication. The first step is to set up a user account to use only for replication. It's best not to use an existing account for security reasons. To do this, enter an SQL statement like the following on the maste
Backup your MySQL databases automatically with AutoMySQLBackup | MDLog:/sysadmin
by 2 othersWith mysqldump anyone can write a small shell script and running it from cron, it will achieve an automatic backup solution. There are many such scripts already available freely and also many commercial solutions also (I assume as I have not tested any re
1
(6 marks)
