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...
The general steps to make a manual backup are as follows:
- Compress and download the SQLite database file (.db) by SFTP.
- Complete a backup.
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
Access the Download URL of SQLite
Run these commands
# Download sources of SQLite, the URL below only for your reference
# Make it
tar zxvf sqlite-autoconf-3290000.tar.gz
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/ld.so.conf.d/sqlite3.conf
sudo echo "/usr/local/lib" |tee /etc/ld.so.conf.d/sqlite3.conf
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?