docs/user_guide/backup-restore.md
Beekeeper Studio provides an interface to native tools to easily backup and restore your databases.
pg_dump and pg_restoremysqldump and mysqlsqlite3Backup and Restore can both be found in the tools section of the app menu:
After selecting either Backup or Restore, you will be guided through a series of steps to generate the command for the vendor provided database tool.
The Backup tab:
The Restore tab:
Here you can choose what you want to back up from your database. For all supported dialects, not selecting any entities will result in a full database backup.
This is where you will configure exactly how the native backup/restore tool will behave. We have a selection of commonly used settings that we can place for you with the click of a checkbox or a selection from a dropdown.
If an option you need is not supported, we also provide you with the ability to add custom flags to the command.
Finally you get to see the generated command that will be run (minus any sensitive information, which is provided in environment variables).
If you would prefer to run this command in the terminal yourself, you can copy it to your clipboard here as well! You may have to set some environment variables to allow the tool to properly connect to your database.
Otherwise, you can let us run the command for you and watch it happen in-app.
If you choose to run the process in-app, you can monitor the command's progress as it executes from this screen:
We show the last 100 or so lines of the logs for you to read through as the tool does its thing, but if something goes very wrong, we also dump all of the logs to a temporary file for all your debugging needs.