Backup/Restore¶

Backup¶

MySQL data - A cron job is scheduled to run every Sunday morning at 00:45. MySQL data is backed up to disk. The sequence is as follows:

service mysqld stop
move old tuleap-bin.index, tuleap-bin.001, sqldump.<last week's date/time>
dump of /var/lib/tuleap/backup/mysql/sqldump.<date>.<time> /var/lib/mysql
service mysqld start
reads /etc/my.cnf
new tuleap-bin.index created
new tuleap-bin.001 created

Database Restore¶

Two files are needed to rebuild. Find the most recent “dump” and “bin” files:

$ cd  /var/lib/tuleap/backup/mysql
$ ls -lt
# Example:
# sqldump.080502.004501 (created from cron "dump" every Sunday; mysql is shut down prior to "dump")
$ service mysqld stop
$ cd  /var/lib
$ mv  mysql  mysql.bck

Then restore the mysql databases from sqldump.080502.004501.

$ tar -vxf tuleap/backup/mysql/sqldump.080502.004501.tar

Then, change the ownership and the security context of the directory:

$ chown -R mysql:mysql /var/lib/mysql
$ chcon -R system_u:object_r:mysqld_db_t /var/lib/mysql

Finish the mysql rebuild by reloading data from tuleap-bin.000001, which contains changes since sqldump.080502.004501 was created. Boot system in single user mode: We don’t want anyone trying to update the mysql database before everything has been restored. Before reloading date, you have to update /etc/my.cnf : Replace :
```
[client]
default-character-set=utf8
```
by:
```
[client]
loose-default-character-set=utf8
```
And then:
```
service mysqld  start
cd  /var/lib/
/usr/bin/mysqlbinlog  mysql.bck/tuleap-bin.000001  |  mysql --user=root  -p
password: (enter root password)
```
No information will display until it’s finished.

Rebuild is complete.

Backup/Restore files¶

There are a number of files used for backup and restore of Tuleap.

/var/lib/tuleap/backup/mysql

The three most current files found in this directory are:

sqldump.<date>.<time>: dump of /var/lib/mysql
tuleap-bin.index: Text file indicating file name to use when restoring mysql data
tuleap-bin.001: Binary log file used for viewing or piping into a mysql command if rebuilding database

Older files are stored in /var/lib/tuleap/backup/mysql/old

/etc

The file found in this directory is:

my.cnf: This file is read when mysql starts. MySQL variables are set here.