homepage Welcome to WebmasterWorld Guest from 54.196.197.153
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
Forum Library, Charter, Moderators: bakedjake

Linux, Unix, and *nix like Operating Systems Forum

    
Messed up MySQL install
Frank_Rizzo




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

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.

PS
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]

 

Frank_Rizzo




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

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.

seindal




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

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
and
/etc/init.d/mysql stop

to control it.

I hope this helps you a bit.

René.

Frank_Rizzo




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

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.

Cheers

seindal




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

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

René.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved