> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/backup-and-restore.md).

# Backup & Restore

## **Backup Database**

You can backup your data into a dump file to save on your hard drive:

* If you are in the welcome screen, click on the **`Backup`** button
* If you are connected to the database, navigate menu **`File`** > **`Backup...`**
* Then choose the **connection**, **database**, and add options if you need them, and hit **`Backup`**.
* Select destination folder and **`Start Backup`**.

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrtE1v94o6zMQ-Irdd0%2F-LrtJCPcBZ0VGvywayBG%2Fbackup-data.png?alt=media\&token=bb18b565-e034-463d-9c46-b65660ffac0a)

## **Restore Database**

You can restore the database from a backup file:

* If you are in the welcome screen, click on the **`Restore`** button.
* If you are connected to the connection, navigate the the menu **`File`** > **`Restore...`**
* Then choose the connection, database, and add options if you need, and hit **`Restore`**
* Select the backup file from your hard drive, and **`Start Restore.`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrtE1v94o6zMQ-Irdd0%2F-LrtJGHecC-AKSVFY98A%2Frestore-data.png?alt=media\&token=057c2397-ee3f-445d-8579-551c0621a0b3)