TablePlus
There are many database tools you can use to connect and manage your database. TablePlus allows you to manage all the database types you can host on Sevalla, so we’re using it for this guide.
You can use any database client or tool (including the command line) which supports your database type. While some specifics, like navigation and field names, may vary between database tools, the fundamental concepts are the same.
If you haven’t already, download and install TablePlus or the database client of your choice on your local machine.
Connect to a Sevalla database
-
In TablePlus, click Create a new connection, choose the database type, and click Create.
Create a new database connection in TablePlus.
-
Complete the connection details in TablePlus with the information from your database’s External connections details in Sevalla and click Connect once you’ve filled in the following:
-
Host/Socket
-
Port
-
User (This is not required for Redis.)
-
Password
-
Database (This is not required for Redis.)
Database connection details in TablePlus.
Database external connections information in Sevalla.
-
-
You are now connected to the Sevalla database, and you can use TablePlus to view and manage the database.
Backup a database
We provide automated and manual backups for databases, but if you need to download a copy of your database, you can export it with TablePlus.
-
In TablePlus, click File > Backup, choose your connection and database, and click Start backup.
Back up a database in TablePlus.
-
Enter a file name for the backup, choose where you want to save it, and click Start backup.
Start your database backup in TablePlus.
Restore a database
You can restore automatic or manual backups that are stored in Sevalla, but if you need to restore a backup that isn’t in Sevalla, you can restore it with TablePlus.
When a database backup is restored, all changes to the database will be rolled back to the time the backup was created.
-
In TablePlus, click File > Restore, choose your connection and database, and click Start restore.
Restore a database in TablePlus.
-
Browse to the file you want to restore and click Start restore again.
Start your database restore in TablePlus.