Any Redhat 4.0 ES Experts On here?

Hang on, hang on, hang on! DO NOT FORMAT THE SYSTEM!

The guy has a problem with mysql, and people are suggesting formatting and reinstalling the enitre machine? Do none of the previous repliers have a clue about Linux? (Hint: i know at least one does).

Right, now i've got that off my chest. I haven't used mysql in ~5 years, so i wont be much of use.

However, if you have a backup i.e. a recently mysql_dump then you have options to (re)move the files under /var/lib/mysql and import the files back into mysql. (This is likely the quickest way, if the data doesnt change much from the backup you have).

If the data changes, or you dont have a backup, a quick bit of googleing i found this. It may be of help.

Dan

N.B FreeBSD on servers or debian if you must use linux. Ubuntu on the desktop.

[SoulKiss]

Originally Posted by Sudoxe

Hang on, hang on, hang on! DO NOT FORMAT THE SYSTEM!

The guy has a problem with mysql, and people are suggesting formatting and reinstalling the enitre machine? Do none of the previous repliers have a clue about Linux? (Hint: i know at least one does).

Right, now i've got that off my chest. I haven't used mysql in ~5 years, so i wont be much of use.

However, if you have a backup i.e. a recently mysql_dump then you have options to (re)move the files under /var/lib/mysql and import the files back into mysql. (This is likely the quickest way, if the data doesnt change much from the backup you have).

If the data changes, or you dont have a backup, a quick bit of googleing i found this. It may be of help.

Dan

N.B FreeBSD on servers or debian if you must use linux. Ubuntu on the desktop.

My advice is to run a LIVE CD system so as not to touch the HD's

And Ubuntu on the Server is quite ok - but yes Debian would be better.

Originally Posted by SoulKiss

My advice is to run a LIVE CD system so as not to touch the HD's

And Ubuntu on the Server is quite ok - but yes Debian would be better.

Yea, I missed the bit about it not booting, but its self explanatory to get a bootcd and get the FS' mounted, if the OP is a sysadmin.

Meh

[jamesterror]

Originally Posted by Sudoxe

Hang on, hang on, hang on! DO NOT FORMAT THE SYSTEM!

The guy has a problem with mysql, and people are suggesting formatting and reinstalling the enitre machine? Do none of the previous repliers have a clue about Linux? (Hint: i know at least one does).

Right, now i've got that off my chest. I haven't used mysql in ~5 years, so i wont be much of use.

However, if you have a backup i.e. a recently mysql_dump then you have options to (re)move the files under /var/lib/mysql and import the files back into mysql. (This is likely the quickest way, if the data doesnt change much from the backup you have).

If the data changes, or you dont have a backup, a quick bit of googleing i found this. It may be of help.

Dan

N.B FreeBSD on servers or debian if you must use linux. Ubuntu on the desktop.

CentOS isn't that bad!

I didn't suggest, I stated what I did as it was a boot configuration error caused by an attack on server .

I'm pretty new to linux and trying all sorts of FreeBSD on home server and so far I found Debian is +1

[SoulKiss]

Originally Posted by Sudoxe

Yea, I missed the bit about it not booting, but its self explanatory to get a bootcd and get the FS' mounted, if the OP is a sysadmin.

Meh

I was going for the easiest non-technical options - the original post indicated thats what was needed.

[SoulKiss]

Originally Posted by jamesterror

CentOS isn't that bad!

Centos ~= Dead Rat == Bad

Hmmm RPM-Hell anyone?

I haven't been really technical for a few years, but my Network Admin is off all week and unable to get him in and unforutately due to the credit crunch there is not a second member which we used to have.

So that leaves me.

I have had to remember how to create VLAN's and rebuild switches, this week too, so when the 2 linux boxes crashed I could've cried.........

I knew there was some geniuses on here hence the post.

The other option is to call Red Hat's technical support (01252 362700, it's one of the menu options off there). Assuming you have a valid support entitlement, of course (which you should if you're using RHEL). Sounds very much like the problem is with MySQL, but they should hopefully be able to help you - assuming you're using the RH supplied MySQL packages. I suspect you'll be told "reinstall from backup" - but they'll at least be able to help you through the process.

If you still get stuck, drop me a PM.

Oh, hello BTW - this is my first post to the .org

Originally Posted by krhall

I haven't been really technical for a few years, but my Network Admin is off all week and unable to get him in and unforutately due to the credit crunch there is not a second member which we used to have.

So that leaves me.

I have had to remember how to create VLAN's and rebuild switches, this week too, so when the 2 linux boxes crashed I could've cried.........

I knew there was some geniuses on here hence the post.

Kev, as you're clearly in a bind at the mo, I won't get into the whole Linux debate that's going on above; how far have you got with the MySQL DB recovery?

Now, what I would do in this situation, is similar to SoulKiss, with a little tweak (as you're only interested in MySQL DB backup).

I personally, would boot from the Live CD of your choice (Ubuntu is as good as any), then setup a dummy MySQL server in the live environment. Shut that daemon down, and symlink the old /var/lib/mysql (the one on the hard disk), to the new one in the live environment. Then start the daemon & use mysql_dump to dump the databases.

Once that's done, you can then simply import the dumps into a new database on the new server, and away you run.

Also, a conversation for when the normal admin gets back, ask him about redundancy for this particular area of the setup. IMO, you should of just been able to rip the disks out & shove them in the next server (assuming the fault is BIOS/boot sequence related). If the problem is with OS changes stopping the boot, then what changed & when? Why was this change not approved (and tested) before being implimented in this situation?

[timwilky]

£1,500/day + expenses I will get it back for you. (eventually promise)