Project

General

Profile

MySQL backup » History » Version 4

« Previous - Version 4/5 (diff) - Next » - Current version
Dmitry Chernyak, 11/23/2011 04:16 PM


MySQL backup

We're backing up MySQL database via shutdown/startup procedure.

Despite some disadvantages, it will be the best choice for many sites because:
  • This is much faster than the dump in the backup.
  • This is very much faster than the restoring from the dump.
  • This allowing to not differ between MyISAM and InnoDB.
  • This allowing to save traffic via duplicity's block-based incremental alogrithms (implemented via librsync).

To do the backup you have to place the following files in your mysql backup job's profile.

File "pre"

if [ `ps ax|grep mysqld|grep -v grep|wc -l` -eq 0 ]; then
  mysql_stopped=yes
  echo "Warning: MySQL is not running." 
else
  /etc/init.d/mysql stop
  sleep 5
  if [ `ps ax|grep mysqld|grep -v grep|wc -l` -gt 0 ]; then
    echo "Error: MySQL is not stopped. Skiping backup" 
    exit 1
  fi
fi

File "post"

if [ -z "$mysql_stopped" ]; then
  /etc/init.d/mysql start
  sleep 5
  if [ `ps ax|grep mysqld|grep -v grep|wc -l` -eq 0 ]; then
    echo "Error: MySQL is not restarted properly. Take care." 
    exit 1
  fi
fi