MySQL DB Backup & Restore

MySQL DB Backup & Restore

MySQL Administrator - DB Backup/Restore

Backup Procedure
1) Open MySQL Administrator on the server and select the appropriate logon details
  • Server Host: localhost
  • Username: root
  • Password: root
2) Select "Backup" from the panel on the left

3) Click on "New Project" and from the "Schemata" select "Actus4", then click on the ">" to view the DB Contents for Backup

4) By Default, keep all "Data directory" contents selected, then Click on "Execute Backup Now" button, select a name for the Backup file and click "Save"


Restore Procedure
1) Open MySQL Administrator on the server and select the appropriate logon details
  • Server Host: localhost
  • Username: root
  • Password: root
2a) Select "Catalogs" from the panel on the left, from the "Schemata" list
2b) Select "Actus4" and Right-Click it and press "Drop Schema"
2c) When asked to confirm, press "OK", then when asked to remove privileges, press "No"

3) Select "Restore" from the panel on the left

4) Click on "Open Backup File" and select the Backup file you saved previously, and the DB will be restored.

    • Related Articles

    • MySQL - Issues

      Issue: When installing MySQL and the MySQL Instance gets stuck during "Start Service" Bug: This can occur if the Windows is located on a system which is over 2TB sized, this is a known bug in MySQL Solution: Windows Installation must be on a ...

    • ActTS - Automatic Uploading of EPG/Guide

      Step 1: SystemConfig - Creating the TS Go to the C:\Actus\Bin folder and run the SystemConfig tool If your system has an active license of Transport Stream, then you will have that section appearing in the left panel SystemConfig - TS ...

    • Export Menu Doesn't Appear

      When selecting to "Edit Clip" to create a Project, the Export resource menu does not appear This can be caused when the channel configuration does not match the Database configuration (eg: Bitrate / Resolution are different) To verify this, open the ...

    • ActTS - Channel Configuration

      ActTS tool allows the system to Capture Transport Stream (.ts) sources directly without encoding involved, preserving all the source quality and information. In order to do this, we need to edit two configuration files: ActControl.cfg - This will ...