bt 面板面板里显示不出的域名和数据库信息

/panel/data/db/site.db

面板里显示的域名文件所在数据库:

面板里搜的到的包含域名文件:

 

SQLite在Windows上的管理工具

cd /www/server/panel/data/db

[root@16217-139 data]# sqlite3 site.db

sqlite> .help

查看数据库文件信息命令(注意命令前带字符'.'):
sqlite>.database

查看所有表的创建语句:
sqlite>.schema

查看指定表的创建语句:
sqlite>.schema table_name

以sql语句的形式列出表内容:
sqlite>.dump table_name

设置显示信息的分隔符:
sqlite>.separator symble
Example:设置显示信息以‘:’分隔
sqlite>.separator :

设置显示模式:
sqlite>.mode mode_name
Example:默认为list,设置为column,其他模式可通过.help查看mode相关内容
sqlite>.mode column

sqlite> .exit

 

 

INSERT INTO "domain" VALUES(2,2,'www.banggoumai.com',80,'2023-12-15 14:42:37');
INSERT INTO "domain" VALUES(3,2,'banggoumai.com',80,'2023-12-15 14:42:37');
==================== 显示域名方法:========================
#sqlite3 site.db
sqlite>.schema
sqlite>.schema domain
sqlite> .dump domain
sqlite> DELETE FROM domain WHERE id = 5;
sqlite> INSERT INTO "domain" VALUES(5,2,'a152.always.co',80,'2023-12-15 14:42:37');
sqlite> .dump sites

INSERT INTO "sites" VALUES(2,'a152.alwaysme.co','/www/wwwroot/a152.always.co','1',NULL,'a152.always.co','2023-12-14 16:19:47',0,'0000-00-00','PHP','{}','');
============================================

# sqlite3 database.db

sqlite>.dump database_servers
sqlite>.dump databases

INSERT INTO "databases" VALUES(1,0,'dfsdf','dfsdf','BT-0x:YyJvft3p7FwSMOHHtRXLJICd7dirSVUNK5MRhfywFrI=','127.0.0.1','dfsdf','2023-12-25 22:34:22',0,'{}',0,'MySQL');
这边密码采用加密方式,不好搞,得看源码咯
sqlite> DELETE FROM databases WHERE id = 1;


posted @ 2023-12-25 21:33  也许明天  阅读(94)  评论(0编辑  收藏  举报