23rd Mar, 2013, 05:08 AM
This will search for db files in the xbian folder and will optimize those databases. This requires the sqlite3 binaries.
Could be handy when you have a big database and/or made many changes. As it just reorganize/rebuilt the databases and doesn't delete any data, it should be safe to use.
sudo apt-get update
sudo apt-get install sqlite3
sudo /etc/init.d/xbmc stop
for i in `find /home/xbian -iname "*.db"` ; do sudo /usr/bin/sqlite3 $i 'VACUUM;' ; sudo /usr/bin/sqlite3 $i 'REINDEX;' ; done
sudo /etc/init.d/xbmc start
Perhaps something for the xbian-config tool like a kind of "housekeeping" task? ;-)
Could be handy when you have a big database and/or made many changes. As it just reorganize/rebuilt the databases and doesn't delete any data, it should be safe to use.
Terminal
sudo apt-get update
sudo apt-get install sqlite3
sudo /etc/init.d/xbmc stop
for i in `find /home/xbian -iname "*.db"` ; do sudo /usr/bin/sqlite3 $i 'VACUUM;' ; sudo /usr/bin/sqlite3 $i 'REINDEX;' ; done
sudo /etc/init.d/xbmc start
Perhaps something for the xbian-config tool like a kind of "housekeeping" task? ;-)