pve配置文件数据库-笔记

/var/lib/pve-cluster/config.db

列出所有 VM / CT的ID

SELECT
  SUBSTR(name, 1, LENGTH(name)-5) AS vmid,
  name
FROM tree
WHERE name LIKE '%.conf';

列出某个虚拟机ID的配置信息

SELECT data FROM tree
WHERE name = '102.conf';

查询所有的虚拟机配置信息

SELECT * FROM tree WHERE name LIKE '%.conf';

导出配置文件到id.conf

mkdir -p export

sqlite3 old-pve-config.db \
"SELECT name FROM tree WHERE name LIKE '%.conf' AND name GLOB '[0-9]*.conf';" |
while read -r name; do
    vmid="${name%.conf}"
    echo "Exporting VMID $vmid ..."
    sqlite3 old-pve-config.db \
        "SELECT data FROM tree WHERE name='${name}';" \
        > "export/${vmid}.conf"
done