LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-21-2005, 07:45 AM   #1
murr4y
LQ Newbie
 
Registered: Jun 2005
Posts: 17

Rep: Reputation: 0
MySQL won't start after reinstallation


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?
 
Old 06-21-2005, 08:45 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,519

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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.
 
Old 06-21-2005, 08:52 AM   #3
murr4y
LQ Newbie
 
Registered: Jun 2005
Posts: 17

Original Poster
Rep: Reputation: 0
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?
 
Old 06-21-2005, 09:20 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,519

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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.
 
Old 06-21-2005, 03:36 PM   #5
murr4y
LQ Newbie
 
Registered: Jun 2005
Posts: 17

Original Poster
Rep: Reputation: 0
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.

Last edited by murr4y; 06-21-2005 at 03:37 PM.
 
Old 06-22-2005, 03:47 AM   #6
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,519

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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!
 
Old 06-22-2005, 05:27 AM   #7
murr4y
LQ Newbie
 
Registered: Jun 2005
Posts: 17

Original Poster
Rep: Reputation: 0
Ah, ok.. Now I get it
I just forgot to set the permissions
It works now
Thanks for your help bathory!!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 07:23 AM
mysql reinstallation distorted by previous tables in /var/mysql mad4linux Linux - Software 0 10-04-2005 02:39 PM
MySQL doesn't start! NetRAVEN5000 Slackware 2 06-17-2005 04:18 PM
MySQL won't start Ephracis Linux - Software 3 12-27-2004 09:54 AM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 07:12 PM


All times are GMT -5. The time now is 09:02 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration