Dbdump

This is just a simple script that will find all .db3 or .db files and dump them to the  directory as HTML, so you can easily poke around to see if there is anything interesting.

SQLITE3=/usr/bin/sqlite3 FOLDER=/media/internal/dbdump INDEX=$FOLDER/index.html DB=1
 * 1) !/bin/ash

getTables { $SQLITE3 $1 .tables }

dumpTable { db=$1 tableName=$2 fileName=$3 $SQLITE3 $db <> $fileName .mode html .header ON .nullvalue --NULL-- select * from $tableName; .exit EOF }

if [ -d $FOLDER ] then rm -rf $FOLDER.bak mv $FOLDER $FOLDER.bak fi

mkdir $FOLDER

files=`find / -name '*.db' -o -name '*.db3'`

cat < $INDEX dbdump EOF

for db in $files do echo "DB:$db" echo "$db" >> $INDEX dbFolder=$FOLDER/db$DB dbIndex=$dbFolder/index.html mkdir $dbFolder echo "dbdump - $dbTables<UL>" > $dbIndex tables=`getTables $db` for table in $tables do               echo "  - $table" echo "<LI/><A href='db$DB/$table.html'>$table</A>" >> $INDEX echo "<LI/><A href='$table.html'>$table</A>" >> $dbIndex tablePage=$dbFolder/$table.html echo "<HTML>dbdump - $db/$table</TITLE></HEAD><BODY> </BODY></HTML>" >> $tablePage done echo "</UL>" >> $INDEX echo "</UL>" >> $dbIndex echo "Generated: `date`" >> $dbIndex echo "</BODY></HTML>" >> $dbIndex DB=$(($DB+1)) done

echo "Generated: `date`" >> $INDEX echo "</BODY></HTML>" >> $INDEX