Site data backup/site migration

# Site Data Backup / Site Migration

## 1. Site Data Backup

To prevent accidental data loss or to prepare for data migration, it is recommended to perform regular site data backups. The data of MrDoc mainly includes:
- Database (table structure and site content)
- User-uploaded files (images, attachments)

>i The command-line operations below assume the MrDoc code directory is `/opt/MrDoc/`

### 1.1 Database Backup

#### 1.1.1 SQLite (Default Database)

If you are using the default SQLite database, you only need to back up the `/config/db.sqlite` file within the project directory:

```bash
cp /opt/MrDoc/config/db.sqlite /opt/MrDoc/config/db.sqlite.bak
```

#### 1.1.2 MySQL Database

If you have configured a MySQL database, you can use the following command to export the data:

```
mysqldump -u <username> -p <database_name> > mrdoc_backup.sql
```

- `<username>`: database username
- `<database_name>`: the database name used by MrDoc
- The exported `mrdoc_backup.sql` file is the backup file

#### 1.1.3 PostgreSQL Database

If you are using PostgreSQL, you can export with the following command:
```bash
pg_dump -U <username> -W -F c -b -v -f mrdoc_backup.pgsql <database_name>
```

- `-F c` specifies the custom format, which is convenient for restoration
- `-b` includes large objects (such as files)
- `-v` displays the detailed process

#### 1.1.4 Database Data Export

Alternatively, refer to the following documents to export the database data as a `json` file:

- [Open Source Edition Data Export and Import](https://doc.mrdoc.pro/doc/3467/ "Open Source Edition Data Export and Import")
- [Pro Edition Data Export and Import](https://doc.mrdoc.pro/doc/3468/ "Pro Edition Data Export and Import")

### 1.2 Uploaded File Backup

All local files uploaded by users in MrDoc (images, attachments) are located in the `media` folder within the project directory. You can back up this folder directly.

```bash
cp -r /opt/MrDoc/media /path/to/backup/media_backup
```
>i It is also recommended to back up this folder regularly. If OSS storage is used (such as Qiniu Cloud or Alibaba Cloud), you need to use the corresponding platform's tools or API for backup.

## 2. Site Migration

If you need to migrate the site from one server to another, simply copy the entire MrDoc project code directory (the folder cloned via git clone) to the new server, and then deploy it according to the normal [deployment process](https://doc.mrdoc.pro/doc/3958/ "deployment process").

>d If a non-default database is used, be sure to restore the data to the new server's database before deploying MrDoc on the new server, and ensure that the database configuration and permissions are consistent with the previous ones.