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 Kinsta, 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.

Connect to a Kinsta Database

  1. In TablePlus, click Create a new connection, choose the database type, and click Create.
    Create a new database connection in TablePlus.
    Create a new database connection in TablePlus.
  2. Complete the connection details in TablePlus with the information from your database’s External connections details in MyKinsta 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 connection details in TablePlus.
      Database external connections information in MyKinsta.
      Database external connections information in MyKinsta.
  1. You are now connected to the Kinsta 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.

  1. In TablePlus, click File > Backup, choose your connection and database, and click Start backup.
    Back up a database in TablePlus.
    Back up a database in TablePlus.
  2. Enter a file name for the backup, choose where you want to save it, and click Start backup.
    Start your database backup in TablePlus.
    Start your database backup in TablePlus.

Restore a Database

You can restore automatic or manual backups that are stored in MyKinsta, but if you need to restore a backup that isn’t in MyKinsta, 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.

  1. In TablePlus, click File > Restore, choose your connection and database, and click Start restore.
    Restore a database in TablePlus.
    Restore a database in TablePlus.
  2. Browse to the file you want to restore and click Start restore again.
    Start your database restore in TablePlus.
    Start your database restore in TablePlus.
Was this article helpful?