I have lost my database, what should I do?
Apply OS: Windows, Mac, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for SQLite, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
You can recover your database if you have a backup file (.psc / .psb / .pmb) created by Navicat.
Create a new database with the original name, then you should be able to see the backup file in the Backup’s Object List. Right-click/Control-click it and choose Restore Backup.
* All backup are stored within the database folder under the Settings Save Path/Settings Location.
For Windows to Linux 6.x and Windows to Mac, please implement the steps below:
- In Navicat, you can right-click/control-click your backup file then select Extract SQL. Save the extracted SQL to a location.
- Create a new database in Linux/Mac version. Right-click/Control-click the database and choose Execute Batch File/Execute SQL File.