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.

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.

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"