If you already know how to use DBeaver, you can skip to Restore the database to the new bot.
Step 1: Verify server configuration
Make sure you have the latest Linux version installed on your server, including CapRover integration. If not, follow the server setup guide before continuing.Step 2: Create a new unCoded bot instance
Create a new trading bot in unCoded following the bot creation instructions. Ensure you are signed in with your Google account and that your Binance UID is linked.Step 3: Prepare DBeaver
Download and install DBeaver
Download DBeaver from dbeaver.io/download and install it on your device. Other database tools work too, but this guide is based on DBeaver.
Step 4: Connect DBeaver and back up your data
Create a new database connection
Open DBeaver and click New Database Connection in the top left corner.
Enter connection details
Fill in the following fields:
Click Finish.
| Field | Value |
|---|---|
| Host | Your server IP address |
| Port | 5432 |
| Authentication → Password | Your POSTGRES_PASSWORD from CapRover |
Connect to the server
Your server appears in the left sidebar. Select it and click Connect. A green checkmark confirms a successful connection.
Open uncoded_db
Open the database named
uncoded_db. If it does not appear, right-click your connection, select Edit Connection, enable Show all databases, click OK, and reconnect.Step 5: Restore the database to the new bot
Connect the new bot to DBeaver
Repeat the DBeaver connection steps (Step 4) for your new bot instance to establish a connection to the new database.
Restore from backup
Right-click the
uncoded_db database in the new connection, select Tools → Restore, enable Clean Database, select your backup file, and click Start.
