Zero logo

MySQL Database backup restore

The Uniform Server's database backup allows for manual backup and restoring a selected database.


Database backup

The Uniform Server's database backup provides a quick and convenient method to backup a single database. Depending on the database base size this may take a considerable length of time to complete.

From UniController select backup database menu as follows:

MySQL > Database backup

Select and create databse backup

  • 2) Select a database for backing up
  • 3) Optionally change the default name displayed. Note must end in .sql
  • 6) Click Create backup
  • Wait for Backup Complete message this will take a long time for a large database.

Notes:

  • 4) Clears selected database and backup name.
  • 5) Displays help.
Select db to backup or delete

Note 1: The database backup is created in folder: UniServerZ\db_backup_restore

Note 2: The Uniform Server's database backup effectively runs the following "Server Console" command:

mysqldump --user=root --password=root --host=127.0.0.1 --databases db_name > output_file.sql

Database restore

The Uniform Server's database restore provides a quick and covenant method to restore a single database. Depending on the database base size this may take a considerable length of time to complete.

From UniController select restore database menu as follows:

MySQL > Database restore

Restore database

  • 1) Select database name to restore.
  • 4) Click Restore button
  • Wait for Backup Complete message this will take a long time for a large database.

Notes:

  • 2) Displays help.
  • 3) Clears selected database backup name.
Restore selected database

Note 1: The menu option allows you to restore a database from a backup file. The backup files are located in folder UniServerZ\db_backup_restore they either already exist in the folder after you create a database backup or you can copy a file to this folder for restoring.

Note 2: The Uniform Server's database restore effectively runs the following "Server Console" command:

mysql --no-defaults --host=127.0.0.1 --port=3306 --user=root --password=root --execute="source restore_file.sql"