1.安装
yum install sqlite-devel
2.下载编译
wget https://www.sqlite.org/2023/sqlite-autoconf-3440000.tar.gz
tar -xvf sqlite-autoconf-3440000.tar.gz
cd sqlite-autoconf-3440000
./configure --prefix=/home/sqlite3_lib
make
make install
目录结构:
/home/sqlite3_lib\
bin
include
lib
share
取所需即可。
3.编译c例程a.c:
gcc -o a a.c -l sqlite3
MYSQL备份导出:
mysqldump -uroot -pxxxxxxxx icevs > 20231109.sql
数据库从SQL(MYSQL备份出来的数据文件20231109.sql)倒入到sqlite3数据库(a.db):
sqlite3 a.db < 20231109.sql