Author Topic: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!  (Read 6304 times)

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« on: November 03, 2007, 06:01:24 pm »
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

  • Guru
  • ****
  • Posts: 153
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #1 on: November 03, 2007, 11:00:30 pm »
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

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #2 on: November 04, 2007, 12:45:50 am »
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

  • Guru
  • ****
  • Posts: 153
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #3 on: November 04, 2007, 01:16:22 am »
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

  • Guru
  • ****
  • Posts: 158
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #4 on: November 04, 2007, 01:33:07 am »
 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

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #5 on: November 04, 2007, 02:25:19 am »
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

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2428
    • View Profile
    • ago control
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #6 on: November 04, 2007, 01:56:21 pm »
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
rock your home - http://www.agocontrol.com home automation

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: ROYALLY PISSED! LINUXMCE BUILD TOASTED MY WHOLE DB!
« Reply #7 on: November 04, 2007, 05:43:03 pm »
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. :-\
"Change is inevitable. Progress is optional."
-- Anonymous