I'm trying to figure out how to reload mySQL.

Following a power outage at my friend's house, mySQL won't start and thus mythtv can't run.
details...http://forum.linhes.org/viewtopic.php?f=6&t=22829

I did a check and fix of the mythconverg database and that seemed to go ok.
But mySQL still won't start.

After googleing the error messages, I'm seeing that when others have had this problem, they simply reload mySQL, reboot and all comes back to life.

How do I reload mySQL?

How-to advice appreciated.

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

do you have a backup of the database? Get whatever backups you have off of the machine.

_________________
My System

Yes.

Do you know how to reload mySQL?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

By reload do you mean reinstall the application?

If so from root it should be just:


In theory it should not affect any installed databases and simply reinstall the needed modules and programs.

If you mean you have to recreate your database then this is well described in the mythtv wiki.

Hi.

pacman won't work in this case.

see details viewtopic.php?f=6&t=22829

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

ok. Well to be fair I wasn't going around looking for what system you might be on. You are saying you are not on LinHES but actually on KnoppMyth 5.5?

In which case apt-get should be fine. You should be ok to use a mysql version that is of the same vintage (major version eg. 5.0). It does not have to be exactly the same minor version but should be the same or newer. This is a general statement and I have not looked at the change logs to be definitive.

I don't have a 5.5 system to try it on. But if you can find the ISO for 5.5 then you could grab your db and do a test run in say a virtual machine.

Correct, it's a Knoppmyth R5.5 machine.

Scroll to the bottom of the thread I referenced.
I did a test apt-get command (with the -s at the end for simulate mode) and I got a bunch of messages indicating that the repositories from the R5.5 days are no longer available.
So, at this point, I'm not sure how to the mySQL .deb files to re-install?

I theorize that I might be able to extract them from the big KNOPPIX file on the R5.5 install CD?
Cecil (Cesman) must have done that every time he made a new Knoppmyth ISO file.
I've been looking for a how-to on exploding the KNOPPIX file.

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

I would go to the debian releases with a mysql that matches. That's where Knoppmyth got its packages from but I don't recall exactly what stream was used for 5.5; I vaguely recall it may have been sid or the release just before it. Beyond that I won't be much help as its been ages since I've used Debian or KM. Note this project had a massive server failure earlier this summer and a lot of stuff was lost hence why the 5.5 repo is missing. Not sure why the debian releases are missing but someone within that project might have the repos you need if you ask on their forums.

I would choose a mysql that is fairly close just to minimize any dependency issues. If you still have the KM5.5 iso then you could also pull the packages from that as you say. I don't recall if there was an upgrade option on the disk or a re-install to make it easier. It's just too long ago but as you say it may be worth exploring.

I would also seriously consider moving forward to a more recent LinHes release if your repair fails. It gets harder and harder to upgrade as time goes on.

Sorry I can't be more help as I'm rather time constrained at the moment or I would likely dig in to try find a more concrete solution for you.

Thanks for the good intensions.

I'm looking at this page on how to extract and remaster the KNOPPIX file (with focus on the extraction part).
http://wiki.openvz.org/Creating_OpenVZ_LiveCD

It says I need to download cloop to extract the KNOPPIX file to an .img file. Then it looks like I would be able to mount the .img file as a drive and see what's inside?

Does that look familiar to anyone?
I'm guessing this is what Cecil (Cesman) was doing during the Knoppmyth years?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

Use Virtualbox or vmware and just do an install on your main computer and extract whatever you need there. With virtual box you don't even need to burn a disc just point to the iso.

_________________
My System

Yes, good idea. I'm using a VMware Workstation and have a Knoppmyth R5.5 virtual machine loaded.

I'm trying to download and make the cloop application and am getting errors...


The file 'extract_compressed_fs.c' is in the directory, so I'm not sure what's wrong??

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

If I understand correctly, you want to look inside and/or extract from the iso. I've used unsquashfs to do this in the past and it is already installed in /sbin/unsquashfs

No, the ISO file is not what this is about. I've already got the ISO file burned to a CD disc, so I can easily access the contents of the ISO file
I want to go one step deeper than the ISO file. It's the big file called KNOPPIX on the Knoppmyth R5.5 CD that I want to extract the contents of.

Since compiling from source didn't work, I just downloaded the .deb file for cloop and I installed it with


Now, I'm not sure were to find where it got installed so I can run it...

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

Of note, I tried to restore an automatic backup of the mythconverg database file.
They get automatically backed up to /var/backups/

The catch-22 is that since mysql won't run, I can't use mysql to restore the backup!

I started by using gunzip to unzip the more recent, clean mythconverg.sql.gz file.
Then...


I'm trying, but I keep hitting brick walls...

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

Sounds like you are making some progress. I know this sounds dumb, but one thing you need to check is how much free space you have on the drive.

You can check and make sure that the socket defined in the /etc/my.cnf is the same as the one that is specified in the
/Setup / General for database server.

I also remember in an earlier version that wrote the socket number to the /tmp directory. Somehow I changed the permissions on the /tmp dir and the file no longer had the correct permissions so couldn't get the port number and mysql wouldn't start.

Good luck.

Tim