How to Backup and Restore Ingress Database using a Third-Party MySQL Manager Tool

How to Backup and Restore Ingress Database using a Third-Party MySQL Manager Tool

Don't lose your Ingress data! Regularly backing up the database protects your software’s settings and content in case of a crash or hard drive failure. Backups let you restore everything quickly.  Luckily, free MySQL management tools (GUI, admin, etc.) can significantly speed up restoring a large database. You don't need to spend a dime - just download one online!


Backup Process

1. Download the MySQL Manager tool from the link below:

SQLyog installer (64-bit operating system)

https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.2.1/SQLyog-12.2.1-0.x64Community.exe 


SQLyog installer (32-bit operating system)

https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.2.1/SQLyog-12.2.1-0.x86Community.exe 



2. After successfully installing SQLyog Community, run the software to connect to the MySQL database. First, fill in the required Host address, Username, and Port of the MySQL database. Then, click on Test Connection and Connect.



3. Upon connecting to the localhost database, you should see on the left panel of the window a list of the available databases. Next, right-click on Ingress and select Backup/Export and Backup database as SQL Dump.



4. Click on Structure and Data > Select ALL Object(s) > Choose a folder to store the database. Now that the settings are configured, click 'Export' to start the backup process. The program will inform you when it is completed.



Restore Database

1. In the SQLyog Community software, connect to the localhost database. Right-click on Ingress, select Import and then Execute SQL Script.



2. Specify the backup file path. Click Execute to restore the database.


The restore process for Ingress is now complete, and you can use the Ingress software as usual.