[skyhawk85u]

Now I have my ATV2's set up with MySQL and shared fanart and still have yet to see a crash or bomb I don't think. I have them both set up for direct boot into XBMC so any crash to frontrow would end up back in XBMC anyway. I'm VERY impressed so far with the latest.

[ecsousa]

Hello,

I've come up with a script to restore the databases (and exit XBMC, by killing AppleTV process) when it gets corrupted:

Code:

#!/bin/bash

killall AppleTV
sleep 4;
for f in ~/Library/Preferences/XBMC/userdata/Database/*.db;
do
    mv $f $f.orig;
    sqlite3 $f.orig .dump | sqlite3 $f;
    rm $f.orig;
done;

echo Done!

I known this is not a solution. But I hope it will help everyone while developers are getting into the issue.

[Memphiz]

Hello,

I've come up with a script to restore the databases (and exit XBMC, by killing AppleTV process) when it gets corrupted:

Code:

#!/bin/bash

killall AppleTV
sleep 4;
for f in ~/Library/Preferences/XBMC/userdata/Database/*.db;
do
    mv $f $f.orig;
    sqlite3 $f.orig .dump | sqlite3 $f;
    rm $f.orig;
done;

echo Done!

I known this is not a solution. But I hope it will help everyone while developers are getting into the issue.

Mhhh nice - i think you should add that you need to install sqlite3 before (apt-get install sqlite or apt-get install sqlite3 or so?!?)

[ecsousa]

Sorry,

Indeed, you will need to install sqlite3 in order to the script to work.

Code:

apt-get install sqlite3

[Memphiz]

Sorry,

Indeed, you will need to install sqlite3 in order to the script to work.

Code:

apt-get install sqlite3

you can edit your post and add it ...