Dbdump - Revision history

XP1 at 11:28, 4 September 2011

2011-09-04T11:28:57Z

Hopspitfire at 20:24, 27 August 2009

2009-08-27T20:24:02Z

Hopspitfire at 10:01, 2 August 2009

2009-08-02T10:01:25Z

Hopspitfire: New page: This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as html so you can poke around easily to see if there's anything int...

2009-07-20T22:44:58Z

New page: This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as html so you can poke around easily to see if there's anything int...

New page

This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as html so you can poke around easily to see if there's anything interesting.

<pre><nowiki>
#!/bin/ash

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

getTables() {
$SQLITE3 $1 .tables
}

dumpTable() {
db=$1
tableName=$2
fileName=$3
$SQLITE3 $db <<EOF >> $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 <<EOF > $INDEX
<HTML><HEAD><TITLE>dbdump</TITLE></HEAD><BODY>
EOF

for db in $files
do
echo "DB:$db"
echo "<HR/>$db<UL>" >> $INDEX
dbFolder=$FOLDER/db$DB
dbIndex=$dbFolder/index.html
mkdir $dbFolder
echo "<HTML><HEAD><TITLE>dbdump - $db</TITLE></HEAD><BODY>Tables<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><HEAD><TITLE>dbdump - $db/$table</TITLE></HEAD><BODY><TABLE border=1>" > $tablePage
dumpTable $db $table $tablePage
echo "</TABLE></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

<pre><nowiki>

← Older revision		Revision as of 11:28, 4 September 2011
Line 1:		Line 1:
−	This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as ~~html~~ so you can easily poke around to see if there's anything interesting.	+	This is just a simple script that will find all .db3 or .db files and dump them to the <code>/media/internal/dbdump</code> directory as HTML, so you can easily poke around to see if there is anything interesting.

	<pre><nowiki>		<pre><nowiki>

← Older revision		Revision as of 10:01, 2 August 2009
Line 1:		Line 1:
−	This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as html so you can poke around ~~easily~~ to see if there's anything interesting.	+	This is just a simple script that will find all .db3 or .db files and dump them to the /media/internal/dbdump directory as html so you can easily poke around to see if there's anything interesting.

	<pre><nowiki>		<pre><nowiki>

@@ Line 2: / Line 2: @@
 <pre><nowiki>
 #!/bin/ash
 SQLITE3=/usr/bin/sqlite3
 FOLDER=/media/internal/dbdump
@@ Line 69: / Line 69: @@
 echo "</BODY></HTML>" >> $INDEX
-<pre><nowiki>