Skip to main content
Version: 1.0

SQLite Maintenance

This chapter is special guide for SQLite maintenance and settings. And you can refer to Administrator and Steps after installing for some general settings that including: Configure Domain, HTTPS Setting, Migration, Web Server configuration, Docker Setting, Database connection, Backup & Restore...

Maintenance guide

SQLite Backup

The general steps to make a manual backup are as follows:

  1. Compress and download the SQLite database file (.db) by SFTP.
  2. Complete a backup.

SQLite Upgrade

If there no newer rpm/deb package for you SQLite, you should update it as below steps:

You should complete an image or snapshot backup for instance before upgrade

  1. Access the Download URL of SQLite

  2. Run these commands

    # Download sources of SQLite, the URL below only for your reference

    # Make it
    tar zxvf sqlite-autoconf-3290000.tar.gz
    cd sqlite-autoconf-3290000/
    ./configure --prefix=/usr/local
    make && make install

    # Replace the old version
    mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
    ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite3
    echo "/usr/local/lib" > /etc/
    sudo echo "/usr/local/lib" |tee /etc/
    sqlite3 -version


In addition to the SQLite issues listed below, you can refer to Troubleshoot + FAQ to get more.

How can I use CloudBeaver to manage SQLite databases?

CloudBeaver just only manage database in the directory: /data/apps/cloudbeaver/volumes


Does SQLite need username and password?


What is the installation method of SQLite in this project?


SQLite 有系统服务吗?