Welcome to WebmasterWorld Guest from

Forum Moderators: bakedjake

Message Too Old, No Replies

Messed up MySQL install



12:05 am on Jan 30, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

I messed up the MySQL install on me dedicated server. MySQL was installed as per standard image but for some reason I installed the lastest binary install instead of using the debian apt-get stuff.

Cut a long story short, MySQL does work but the configs are all out.

I can't now get Webmin to access it, and the startup / shutdown commands don't work. I guess this could be due to paths changed from the original apt install from when the binary was installed.

I tried removing mysql by using apt-get remove and then reinstalling but its still not configured right.

How do I *totatlly* toast all of MySQL so that I can reinstall with the proper apt-get?

Please note that I have data tables that I'd like to keep.

I know I messed up here, and I'm not getting much help from the server support droids so I'm in the wilderness a bit here.

[edited by: Frank_Rizzo at 12:07 am (utc) on Jan. 30, 2003]


12:07 am on Jan 30, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

Just to add,

to start it I have to do:

bin/mysqld_safe &

and to stop it:

kill cat `myhost.pid`

Is that right? It works.


7:35 am on Jan 30, 2003 (gmt 0)

10+ Year Member

I'm not quite sure I understand.

You had mysql installed via apt-get.
Then you installed another binary package on top of that?
If yes, what kind of binary package?

You will have to clean it up completely and then reinstall. Otherwise you risk having files from the wrong distribution around.

If you have installed the second package from a simple tar archive (a .tar.gz or a .tgz file), then you can use

tar tvfz FILE

to get a list of the files installed. You will have to remove those files by hand, just as you installed them by hand.

Once you have cleared out the second manual install, flush the debian install with

dpkg -P mysql-server

At that point you should be able to start from scratch and reinstall mysql, webmin etc.

If you stick with debian's packages, you'll get installations of mysql and webmin that work together.

As for starting and restarting, in Debian you use

/etc/init.d/mysql start
/etc/init.d/mysql restart
/etc/init.d/mysql stop

to control it.

I hope this helps you a bit.



11:20 am on Jan 30, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

The server was to be 'reimaged' so I decided to play around with it. The reimage never came about in the end so thats why its in the state its in now.

Yes, I downloaded the binary tar from mysql and did the make, config etc. for that.

I'll try toasting it again tonight using the debian flush commands.



11:25 am on Jan 30, 2003 (gmt 0)

10+ Year Member

If you installed from source, you can also do a "make uninstall" in the source directory.



Featured Threads

Hot Threads This Week

Hot Threads This Month