PHP and MongoDB database backup and recovery

With the advent of the big data era, data backup and recovery are becoming more and more important. In this process, many websites will use PHP and MongoDB databases to back up data. This article will introduce how to use PHP to write MongoDB database backup and recovery scripts.

1. MongoDB database backup

MongoDB database backup is divided into two methods: manual backup and automatic backup.

1. Manual backup

Manual backup can be achieved through the MongoDB command line tool mongodump. The mongodump command can back up the data of the specified database to the specified directory. The syntax format of this command is as follows:

mongodump –-db 6b7267f525327f2a23dcb01791a146aa -o 83cf7a2f7c33d3ad4d0e264fea635126

For example, to back up the my_database database, you can execute the following command:

mongodump –-db my_database -o /backup/my_backup/

This command will back up the my_database database and store the backup file in the /backup/my_backup/ directory.

2. Automatic backup

Automatic backup scripts can be written in PHP language and use CRON scheduled tasks to achieve scheduled backup. The following is a simple backup script:

<?php
// 定义备份路径
$backup_path = '/backup/my_backup/';

// 连接MongoDB数据库
$m = new MongoDBClient("mongodb://localhost:27017");

// 指定要备份的数据库
$db = $m->my_database;

// 备份所有集合
$collections = $db->listCollectionNames();
foreach ($collections as $collection) {
    $command = 'mongodump --db my_database --collection '.$collection.' --out '.$backup_path;
    exec($command);
}

// 删除14天前的备份文件
$expire_time = strtotime('-14 days');
$files = glob($backup_path.'*');
foreach ($files as $file) {
    if (filemtime($file) < $expire_time) {
        unlink($file);
    }
}
?>

This script will back up all collections in the my_database database and store the backup files in the /backup/my_backup/ directory. At the same time, it will also delete backup files from 14 days ago.

2. MongoDB database recovery

MongoDB database recovery is also divided into two methods: manual recovery and automatic recovery.

1. Manual recovery

Manual recovery can be achieved through the mongorestore command. This command can restore the data in the backup file to the specified database. The syntax format of the command is as follows:

mongorestore –-db 6b7267f525327f2a23dcb01791a146aa 83cf7a2f7c33d3ad4d0e264fea635126

For example, to restore the backup files in the /backup/my_backup/ directory to the my_database database, You can execute the following command:

mongorestore –-db my_database /backup/my_backup/

This command will restore the data in the backup file to the my_database database.

2. Automatic recovery

Automatic recovery can be achieved through automated scripts written in PHP language. The following is a simple recovery script:

<?php
// 定义备份路径
$backup_path = '/backup/my_backup/';

// 连接MongoDB数据库
$m = new MongoDBClient("mongodb://localhost:27017");

// 指定要恢复的数据库
$db = $m->my_database;

// 恢复备份文件
$backup_files = glob($backup_path.'*');
foreach ($backup_files as $backup_file) {
    $command = 'mongorestore --db my_database '.$backup_file;
    exec($command);
}

// 删除14天前的备份文件
$expire_time = strtotime('-14 days');
$files = glob($backup_path.'*');
foreach ($files as $file) {
    if (filemtime($file) < $expire_time) {
        unlink($file);
    }
}
?>

This script will restore the backup files in the /backup/my_backup/ directory to the my_database database. At the same time, it will also delete backup files from 14 days ago.

Summary:

Using PHP to write MongoDB database backup and recovery scripts can make data backup and recovery more convenient and efficient. At the same time, automated backup and recovery scripts can also reduce the error rate of manual operations. It should be noted that during the backup and recovery process, you must pay attention to the consistency and integrity of the data to avoid irreversible losses.

The above is the detailed content of PHP and MongoDB database backup and recovery. For more information, please follow other related articles on the PHP Chinese website!