Skip to main content

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 有系统服务吗?