User Tools

Site Tools


mysqlbackup

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mysqlbackup [04.02.2014 19:09]
derk
mysqlbackup [04.02.2014 19:16] (current)
derk
Line 2: Line 2:
  
 [[http://​sourceforge.net/​projects/​automysqlbackup/​|AutoMySQLBackup]] is a small backup script for MySQL databases with a handling for daily, weekly and monthly backups. [[http://​sourceforge.net/​projects/​automysqlbackup/​|AutoMySQLBackup]] is a small backup script for MySQL databases with a handling for daily, weekly and monthly backups.
 +
 +The current version in the apt package is 2.5. There are newer versions available on the [[http://​sourceforge.net/​projects/​automysqlbackup/​|AutoMySQLBackup website]].
  
 === Step 1: Install === === Step 1: Install ===
Line 13: Line 15:
 </​code>​ </​code>​
  
-The most important ​Setup values are+The most important ​setup values are:
 <code bash> <code bash>
 USERNAME=XXX USERNAME=XXX
Line 30: Line 32:
 </​code>​ </​code>​
  
 +=== Step 3: Error correction ===
 +I found a small error in version 2.5. The fix is pretty easy.
 +
 +Edit the AutoMySQLBackup script:
 +<code bash>
 +sudo nano /​usr/​sbin/​automysqlbackup
 +</​code>​
 +
 +Replace this line:
 +<code bash>
 +exec 2>&6 7>&​- ​     # Restore stderr and close file descriptor #7.
 +</​code>​
 +with this line:
 +<code bash>
 +exec 2>&7 7>&​- ​     # Restore stderr and close file descriptor #7.
 +</​code>​
mysqlbackup.1391537362.txt.gz ยท Last modified: 04.02.2014 19:09 by derk