MySQL won't start after reinstallation

murr4y · 06-21-2005, 06:45 AM

Hey..!

I downloaded mysq-standard-4.1.12-pc-linux-gnu-i686.tar.gz from mysql.com. Unzipped, moved and renamed to /usr/local/mysql, added user and group mysql copied support-files/my-medium.cnf to /etc/my.cnf, ran ./scripts/mysql_install_db --user=mysql and started mysql and it worked fine.
When I was changing the root password, I screwed up and deleted some stuff I didn't know what was so I decided to reinstall the DB. I deleted the /usr/local/mysql folder and did the process over again. I think I should've stopped the mysql before I deleted the folder (however I do that) but anyway, now, when starting the server, it says:

Code:

[root@localhost mysql]# ./bin/mysqld_safe --user=mysql &
[1] 3691
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid
050621 13:42:57  mysqld ended


[1]+  Done                 ./bin/mysqld_safe --user=mysql
[root@localhost mysql]#

It won't start no matter what I do. I tried restarting the computer. I'm no linux guru... so... does anyone know what I can do to reinstall the db and make it work?

bathory · 06-21-2005, 07:45 AM

Quote:

STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid

If that file exists, delete it because it fools mysqld that it's running.

murr4y · 06-21-2005, 07:52 AM

Thanks for the tip, but I've already checked and it doesn't exists. It looks like some file is created and deleted in the same folder in a milisecond when I try to start it and I think the filename is "localhost.lower-test" but I'm not sure because it disappears so quickly.
Thanks for trying anyway

Any other suggestions?

bathory · 06-21-2005, 08:20 AM

Try to start it without the "&" at the end of the command to see if it spits any errors. Also take a look at the logs in the data directory to see if you find any hint.

murr4y · 06-21-2005, 02:36 PM

Starting without '&' didn't make any difference. But..

Aha! Logs! Why didn't I think of that

/usr/local/mysql/data/localhost.localdomain.err:

Code:

05621 15:24:54 mysqld started
http://home.no.net/rht87/upload/skole/square.png /usr/local/mysql/bin/mysqld: File './localhost-bin.1' not found (Errcode: 13)
050621 15:24:55 [ERROR] Could not use localhost-bin for logging (error 12). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
050621 15:24:55 [ERROR] Aborting

The link is to a square which is some kind of font letter... which is in front of the line for some reason.
Well, how do I fix the cause?? I have no idea what './localhost-bin.1' is

Anyway, thanks for putting me on the right track.

bathory · 06-22-2005, 02:47 AM

localhost-bin.1 is a binary logfile used by mysqld. Everytime you restart it, the extension increases by 1 (localhost-bin.2 etc). You can open localhost-bin.index to see the order of these files. I guess there is something wrong either in your /etc/my.cnf about the location of these logfiles (take a look there for a line log-bin), or you didn't gave the correct permissions in your data directory (owner mysql, group mysql) where these logfiles are written by default. You can also empty localhost.index and delete any localhost-bin.x files. They will be recreated.
As for the URL, I really don't know what is!

murr4y · 06-22-2005, 04:27 AM

Ah, ok.. Now I get it

I just forgot to set the permissions

It works now

Thanks for your help bathory!!