Restoring a SQL backup is a fairly complex procedure and is not for the faint of heart. We will outline the general procedure here, but you may need to contact an IT professional for assistance. Please note that our support team is unable to assist with restoring a database backup.

Before You Begin

• Database backups are in SQL format. Specifically, Gingr uses MySQL. If you're not familiar with SQL files, you may need to hire an IT professional to open them for you.

Open Your Database Backup

1. First, you'll need an SQL Server. The options are: MySQL, MariaDB and Percona. Follow the instructions on their site for installation and configuration on your operating system.
   
   
2. Once you have an SQL Server installed and running, you'll need an SQL Client to view the database in a friendly format. There are many options, but our favorite for MacOS is Sequel Pro and MySQL Workbench for Windows. Follow the instructions on their site for installation on your operating system.
   
   
3. Once you have an SQL Client installed an opened, you'll want to use its restore functionality to restore your Gingr database file. 
   
   
4. Once you've restored your Gingr database file into your SQL Server, you'll be able to view all the data from the backup.

Related Resources

• Data Management Topic Outline
• Backup Your Database How-To
• Backup Your Files How-To
• Data Import Options Reference
• Clear Local Storage How-To
• Clear Test Data How-To
• Merge Duplicate Animals How-To
• Merge Duplicate Veterinarians How-To
• Rebuild Search Index How-To
• Rebuild the Animal Immunizations Index How-To