ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!

[tschak909]

Note to all others, do not run the build scripts on your running DB.
(#$#@(%$@#%@#%*@# !!!!! good thing I have a ....semi-recent backup

FUCK!

-Thom

[danielk]

This just happened to me as well and I didn't have a backup.

I'll fix this portion of the script as soon as I've re-imaged my machine.

I'll post an update here after I do...

[tschak909]

I was able to revert to a tarball i made of the system last week.. It didn't touch the mythconverg database, so I was able to restore that completely...

-Thom

[danielk]

I'm almost 100% sure this happened due to the initialize_build_db step, if you comment out this line in Makefile.linux

     @${RUN} ${SVNROOT} Init_Build_Database ${DB_USER} ${DB_PASSWORD}

It should build all the Ubuntu packages and install all the build dependencies successfully. But I haven't tried this yet on an active LMCE machine.

I need to change the Init_Build_Database portion to use a different name for the build databases so they don't overwrite the LinuxMCE databases. Right now the script drops those databases as part of the build process... As you noted it does not do anything with the MythTV database. The MythTV database is mostly built by the MythTV suite of applications when first run, so there is no need to initialize any databases as part of it's build process. For the LMCE build databases I'll probably prepend "build_" or something similar to avoid the name collision.

On a positive note, I'm trying the Kubunu + LinuxMCE install now, so if there are differences between it and the DVD install that affect the build process I'll be able to adjust the build scripts accordingly.

I'm happy to hear someone else is trying to build the thing from scratch, that's the only way we'll work out all the problems... I'm also very glad you had a backup!

[rafik24]

 I'm one of those that did not have a backup of the sql db and know my core is dead.

 Havent managed to find a way to get the db loaded from scratch.

 FYI

Rafik

[tschak909]

For those who haven't... do a backup of both your system drive (You do have your system drive separate from your media drive, don't you?), and do a separate backup of the database. It will save so much anguish, of course, this is after the initial horror and anger goes away. ;-)

-Thom

[hari]

I'm one of those that did not have a backup of the sql db and know my core is dead.

 Havent managed to find a way to get the db loaded from scratch.

you can use sqlCVS to fix the database. Instructions are in the Wiki.

regards,
Hari

[Zaerc]

I guess I could have told you that, but nobody seemed really interested at the time I "discovered" this: http://forum.linuxmce.org/index.php?topic=2053.msg9492#msg9492

Sorry to hear your frustration, for me it was a nice learning experience restoring a database backup from my production environment and I reckoned that most people wouldn't to use a production machine for development anyway.