Backing Up MySQL

Navigation:  MySQL Governor >

Backing Up MySQL

Previous pageReturn to chapter overviewNext page

This operation will take some time.

 

Execute as root:

 

$ mkdir -p ~/mysqlbkp
$ service mysql restart --skip-networking --skip-grant-tables
$ mysql_upgrade
$ mysqldump --all-databases --routines --triggers > ~/mysqlbkp/dbcopy.sql
$ service mysql stop
$ cp -r /var/lib/mysql/mysql ~/mysqlbkp/
$ service mysql start