Introduction to MySQL Backup

MySQL is one of the most popular relational database management systems worldwide. Regular backup of MySQL databases is crucial for data security and integrity. This article introduces mysql-backup and provides a comprehensive guide on its various APIs to help you with efficient and reliable backup solutions.

API Examples

1. Initializing Backup

To begin with a backup process, you need to initialize the backup. Here’s how to do it:

  const mysqlBackup = require('mysql-backup');
  const backup = mysqlBackup.init({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'my_database'
  });

2. Performing Full Backup

Performing a full backup is essential to ensure all your data is safe. Here’s an example:

  backup.full({
    destination: '/path/to/save/backup.sql'
  }).then(() => {
    console.log('Full backup completed successfully.');
  }).catch(err => {
    console.error('Error during full backup:', err);
  });

3. Incremental Backup

An incremental backup saves only the changes made since the last backup. Useful for saving storage space and time.

  backup.incremental({
    destination: '/path/to/save/incremental_backup.sql'
  }).then(() => {
    console.log('Incremental backup completed successfully.');
  }).catch(err => {
    console.error('Error during incremental backup:', err);
  });

4. Restoring from Backup

Restoration is just as crucial as backing up your data. Here’s how to achieve this:

  backup.restore({
    source: '/path/to/backup.sql'
  }).then(() => {
    console.log('Database restored successfully.');
  }).catch(err => {
    console.error('Error during restoration:', err);
  });

5. Scheduling Backup

Scheduling backups can automate the process for better efficiency:

  const schedule = require('node-schedule');

  schedule.scheduleJob('0 0 * * *', () => {
    backup.full({
      destination: '/path/to/scheduled_backup.sql'
    }).then(() => {
      console.log('Scheduled full backup completed successfully.');
    }).catch(err => {
      console.error('Error during scheduled full backup:', err);
    });
  });

MySQL Backup in an App

Below is a simple Node.js application demonstrating MySQL backup using the described APIs:

  const express = require('express');
  const mysqlBackup = require('mysql-backup');
  const schedule = require('node-schedule');

  const app = express();
  const backup = mysqlBackup.init({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'app_database'
  });

  app.get('/backup', (req, res) => {
    backup.full({
      destination: '/path/to/app_backup.sql'
    }).then(() => {
      res.send('Backup completed successfully.');
    }).catch(err => {
      res.status(500).send('Error during backup: ' + err);
    });
  });

  schedule.scheduleJob('0 0 * * *', () => {
    backup.full({
      destination: '/path/to/scheduled_app_backup.sql'
    }).then(() => {
      console.log('Scheduled app full backup completed successfully.');
    }).catch(err => {
      console.error('Error during scheduled app full backup:', err);
    });
  });

  app.listen(3000, () => {
    console.log('App running on port 3000');
  });

Regularly backing up your MySQL database ensures data integrity and minimizes data loss risks. Use the provided APIs to optimize your backup strategy efficiently.

Hash: db1a0fb7e73612b6530d6818ab4fe120fc6f05dad19b07ec0c3785f241d45092