As an experienced security CMS operator, I know that data is the lifeline of a website, especially when managing multiple sites, the strategy of data backup and recovery is of paramount importance.AnQiCMS was designed with the needs of enterprise-level applications in mind, providing system data backup and recovery features to ensure the safety of users' data assets.For a multi-site environment, we need a clear and efficient strategy to ensure the independence of each site and the integrity of the overall data.

Understanding the data structure of AnQiCMS

Before delving into the specific methods of backup and recovery, it is first necessary to clarify the data composition under the AnQiCMS multi-site environment.According to the architectural features of AnQiCMS, each independent site usually has its own dedicated data storage, which is mainly divided into two core parts: the database and the file system.

The AnQi CMS supports multi-site management, allowing each new site to be configured with an independent database name and site root directory.This means that the data of each of your sites is relatively isolated.The core application files, public resources, and independent databases and file directories of each site together constitute the complete AnQiCMS multi-site data.

The core strategy of multi-site data backup

In view of the characteristics of the AnQiCMS multi-site environment, a comprehensive data backup should cover the following key components:

database backup

Every standalone site created in AnQiCMS will have a dedicated database.This database carries all the structured data of the site, including content (articles, products, pages, etc.), categories, tags, users, configuration settings, and various functional module data.

In order to back up this data, you need to perform independent operations on the database for each site. Common database backup methods include exporting SQL files using database management tools (such as phpMyAdmin, Navicat), or through command line tools (such asmysqldump) Execute the backup command. For example, for MySQL databases, you can execute similar commands for each site's database: 

mysqldump -u [用户名] -p[密码] [数据库名称] > [备份文件路径]/[数据库名称]_backup_$(date +%Y%m%d%H%M%S).sql

Make sure to perform this operation for each site and its corresponding database, and name the backup files properly for easy identification and search.

File system backup

The file system backup mainly includes two types of files: site-specific files and AnQiCMS core program files.

  • The root directory of the site (media resources and configuration)

    Each site is assigned a unique site root directory when created, for example/app/dev_anqicms.com. This directory contains all the media files (such as images, videos, attachments) uploaded by the site, as well as site-specific template files, cache data, and so on.These resources are an indispensable part of the site content display.

    You need to regularly back up all files and folders under the root directory of each site. This can be done using compression tools (such astar/zip) to package the entire directory, or usersyncIncremental backup using tools. It is recommended to separate media resources and configuration files, such as backing up media folders separately, to ensure that recovery can be located quickly in case of failure.

  • AnQiCMS core program file

    In addition to the independent data of each site, AnQiCMS's core program files also need to be backed up. This includes the binary executable files and the mainconfig.jsonConfiguration file (especially including database connection information and port settings, etc.) and shared template files for all sites (if they exist).These files are usually located in the root directory of the AnQiCMS installation.

    Although in multi-site mode, the data of each site is independent, they share the same AnQiCMS program instance.Therefore, the backup of the core program can ensure that a quick redeployment can be carried out in the event of problems at the system level.

Backup plan and frequency

It is particularly important to establish a reasonable backup plan for multi-site environments.The backup frequency should be determined based on the update frequency of your website content, traffic size, and the importance of the data.For sites with frequent content updates, it is recommended to perform database and file system backups daily;For sites that are not updated frequently, weekly or monthly backups may be sufficient.The automated backup script can significantly improve efficiency and reduce human errors.

Steps for data recovery

Data recovery is the ultimate goal of backup work, its purpose is to be able to restore the website to normal operation in the event of data loss or damage.

Database Recovery

When you need to restore the data of a site, you first need to restore the corresponding database. You can use database management tools to import the previously backed up SQL file, or through command-line tools (such asmysql) Execute the recovery command.

mysql -u [用户名] -p[密码] [数据库名称] < [备份文件路径]/[数据库名称]_backup_$(date +%Y%m%d%H%M%S).sql

Please confirm the name of the target database before executing the recovery operation to avoid overwriting incorrect data.

File system recovery

The file system recovery includes restoring the backup site root directory files and AnQiCMS core program files to the specified location.

  • Restore the site root directory

    Extract or copy the backup of the media resources and configuration files of the corresponding site back to its original site root directory.If a file with the same name exists in the directory, it is usually selected to overwrite. After the recovery is complete, make sure the file permissions are set correctly so that the web server can access normally.

  • Restore AnQiCMS core program file

    If the core program file is damaged, you need to backup the AnQiCMS core program (including binary files,config.jsonCopy) back to the main installation directory. After that, you may need to adjust according to the new environmentconfig.jsonSome parameters, such as port numbers, database connection strings, and restart the AnQiCMS service.

Verify recovery

After the data recovery is complete, be sure to conduct a comprehensive test of the restored site.This includes accessing the front page, checking if the content, images, and links are displayed normally;Log in to the backend management interface, verify whether all functions are available;Review the content released recently to ensure data integrity.Only after passing the complete verification can the successful recovery of data be confirmed.

**Practice and Precautions

To better ensure the data security of AnQiCMS multi-site, the following are some recommended practices:

  • Remote storage backup: Store the backup file in a physical location different from the AnQiCMS server or in a cloud storage service to prevent complete data loss due to server hardware failure, natural disasters, and other factors.
  • automated backupUsing scripts or third-party tools to implement automated scheduled backups of databases and file systems, reducing manual intervention, and ensuring timely backups.
  • Regularly test the recovery processDo not wait until a real data disaster occurs before performing recovery tests.Regularly simulate data loss scenarios, perform recovery operations to verify the effectiveness of backup data and the smoothness of the recovery process.
  • Permission managementEnsure that the access permissions of the backup files and directories are strictly controlled to prevent unauthorized access leading to data leakage or tampering.
  • Log recordingRecord all backup and restore operation logs, including time, operator, backup content, etc., for audit and fault troubleshooting.

Frequently Asked Questions

Q1: Do I need to back up the database for each site separately in a multi-site environment?

Yes, AnQiCMS multi-site mode is designed to use an independent database for each site.Therefore, to ensure the data integrity and independence of each site, you must back up the corresponding database for each site separately.If you only backed up the main site's database, then the data for other sites will not be recoverable.

Q2: In addition to the database and site root directory, do you also need to back up AnQiCMS' core program files?

Although the core program files of AnQiCMS usually do not contain website operational data, backing them up is still recommended**practice. Core program files include AnQiCMS executable files, global configuration files (such asconfig.json) etc. Backing up these files ensures that you can quickly restore the running environment if the program itself is damaged or needs to be quickly migrated, especially when you have custom modifications or use a specific version.

Q3: Does AnQiCMS have a built-in graphical interface tool for one-click backup and restore?

According to the description of the advantages of the AnQiCMS project, it provides the core function of "resource storage and backup management".This means that the background management system should have the corresponding configuration and operation entry.In actual operation, you can usually find the relevant options in modules such as "Function Management" or "System Settings" in the background to perform system data backup and recovery settings.The specific interface operation steps should be based on the actual display of the AnQiCMS version backend you are using.