Skip to main content

Joel Liu's Library tagged backup →  View Popular

ONLamp.com -- Live Backups of MySQL Using Replication

  • The last two stanzas above set up logging. The second to last
    stanza starts binary logging as we did on the master server, but this
    time on the slave. This is the log that can be used to allow the
    master and the slave to reverse roles, as mentioned earlier.
02 Mar 06

Painless backups using rdiff-backup : Page 2

    • Both the source and target systems need three things:

      • Python 2.2 or higher
      • SSH
      • A copy of rdiff-backup

Using tar for incremental backups and restores

  • ood and apple pie you’ll probably need a snack between meals - an incremental backup -and perhaps you’ll need to regurgitate what you’ve eaten - to pursue the metaphor just a little too far - and restore files. Here’s how to do these the simp
  • ood and apple pie you’ll probably need a snack between meals - an incremental backup -and perhaps you’ll need to regurgitate what you’ve e

MySQL 5.0 Reference Manual :: 8.10 mysqldump — A Database Backup Program


  • For each table, surround the INSERT
    statements with /*!40000 ALTER TABLE
    tbl_name DISABLE KEYS
    */;     and /*!40000 ALTER TABLE
    tbl_name ENABLE KEYS
    */;     statements. This makes loading the
  • or a collection of databases for backup or for
    transferring the data to another SQL server (not necessarily a
    MySQL

Automated Backups With rdiff-backup | HowtoForge - Linux Howtos and Tutorials

  • But fortunately there is a solution: the use of public keys. We create a pair of keys (on our backup server backup.example.com), one of which is saved in a file on the remote system (server1.example.com). Afterwards we will not be prompted for a password anymore when we run rdiff-backup. This also includes cron jobs which is exactly what we want.
  • This tutorial describes how to do automated server backups with the tool rdiff-backup. rdiff-backup lets you make backups over a network using SSH so that the data transfer is encrypted. The use of SSH makes rdiff-backup very secure because noone can read the data that is being transferred. rdiff-backup makes incremental backups, thus saving bandwidth.

mezzoblue  §  Web Server Backup

  • Get a full local backup of your remote web server with some basic command-line
    interaction and rsync. Bonus for OS X users: clickable icon backup
    goodness.
1 - 18 of 18
Showing 20▼ items per page

Selected Tags

Related Tags

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo