Hi guys I need some help with steps to get a test server back up to normal. I have a raq4 with mysql everthing runs just fine un till I reboot or restart the server. At boot up the server starts everything incluing mysql but after opening mysql it stops it.

A user by the name allending helped me get the server back to normal after he looked into it.

These are his findings.
.....................................................................................................
The problem before wasnt the sockets. They were fine. Unfortunately, although
mysql started, it shutdown right after it started. Of course this meant you couldnt connect since it wasnt running.

To let it run without shutting down, had to reinstall the privelage tables (mysql_install_db) , and then start mysql.
.....................................................................................................

I tried getting the mysql_fix_privlige_tables but could not get it to work because it could not connect to local mysql server (error 2002)

Can anyone tell me what steps need to be made, in step by step to get what he is talking about to work?? I am a novice telnet user but can figure my way around.

allending thanks for figuring this out last time. I understand you are prob busy.

come on guys anyone have any idea?? How can I get mysql to start long enought to exacute the command to rebuild the privilege tables??? :eek:

Why not copy over any databases you need and just re-install MySQL? Might be a LOT easier than trying to do what your doing. Just a thought.

how do you go about copying the data base files so I can rimage the server??

You can find all the databases in /home/mysql/

Just tar them up of cp them to a backup directory.

Ummm, So did it work???

Thanks to allending for bringing it back up again. I was able to backup the data bases after mysql came back up.

Thanks guys for all your help..