Databases
      Back to home
      1. Help Center
      2. Server Administration
      3. Databases

      Creating a database backup

      ISPmanager

      Configuring backup in ISPmanager is performed as root in the Tools - Backups section. Read more in this article.

      Also in the ISPmanager control panel there is a possibility of database backup via data export. Data can be imported and exported using a dump (a file that contains the structure and data of the database). The dump can be used as a backup or to transfer the database to another server

      To export data, go to Tools - Databases - Download. Next, select the path to save the file on your local computer.

      creating-a-database-backup

      VestaCP

      By default, the VestaCP panel backs up once a day. The last three backups are saved.

      It is not necessary to back up the entire server. In order to save resources, only important items can be saved. Click EXCLUSIONS under BACKUP, then the setup icon. You can exclude unnecessary elements here.

      To create a database backup, specify it in the Databases field. Mark the rest of the fields with *. In this case, the backup will only contain the specified database.

      creating-a-database-backup1

      DirectAdmin

      1. Log into DirectAdmin as administrator (admin).
      2. Go to Admin Tools - System Backup.
      creating-a-database-backup2

      In the next window, select the Backup MySQL Databases item. By default, backups are performed every Sunday at 5:00 am. You can change the frequency of the backup. To manually start the backup process, click Run System Backup Now.

      creating-a-database-backup3

      BitrixVM

      In the BitrixVM control panel, a backup copy is created as a .tar.gz archive and saved in the directory /home/bitrix/backup/archive/

      To set up automatic scheduled backups, select 6. Manage sites in the pool > 6. Change backup settings on site.

      creating-a-database-backup4

      In the next step, configure the backup frequency:

      creating-a-database-backup5

      You can also tune your backup:

      /opt/webdir/bin/bx-sites -a backup -d dbcp --enable --minute=10 --hour=18 --day=any --month=any --weekday=any

      Backup archive includes:

      • database dump /home/bitrix/mysql_dump__DD.MM.YYYY_.sql
      • core site data
      • data of sites such as links with full path 

      If you still have questions, please create a ticket to technical support.