Chapter 17. Backing up your more.groupware data
Prev | Part III. Administração do moregroupware | Next

## Chapter 17. Backing up your more.groupware data

Backups are tedious. Especially since we have no backup module yet. But believe me, a backup can save you day, so you should really think about it.

## Backup of your MySQL database

One way to do a manually backup from the command prompt will be described below.

| Note
Agraphical web based tool to help you with the tasks described in this section is phpMyAdmin which can be downloaded from http://www.phpmyadmin.net/

Start a terminal session (Linux) or command prompt (Windows) and enter the following command:

mysqldump --add-drop-table -a -u username -p database > path/to/backup.sql

You must replace `username` with the name of a user that can read the tables in the `database` you use for more.groupware. `path/to/backup.sql` is the path and name to the file that will be written during backup, e. g. `C:\backup\mgwbackup.sql`.

If you get `bad command` or something like that you have to use cd to go to the MySQL bin system folder (e. g. cd C:\mysql\bin) before you run the command again.

After entering the command you have to press the enter key. Input the MySQL password of the user `username` and press enter yet another time. The backup will be dumped to the given file.

Now you have a backup of the database which can be stored at a safe place. But you should also make a copy of the whole moregroupware folder (cp -R mgwfolder backupfolder if you use Linux or the graphical Explorer if you use Windows).

You must do a folder copy to get a backup of your emails which are stored in `modules\webmail2\store`, the contents of the files module and the configuration file called `config.inc.php`.

Prev | Up | Next
Chapter 16. Common user complaints | Home | Restore of your MySQL database