LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

Reply
 
Search this Thread
Old 10-12-2012, 05:12 AM   #1
hua
Member
 
Registered: Oct 2006
Location: Slovak Republic
Distribution: Slackware 13.37, 14.0
Posts: 394

Rep: Reputation: 49
mysql_install_db error


Hello

I recently upgraded my Slackware13.37 server to Slackware14. I used to start my mysql configuration with mysql_install_db script. Unfortunately I cannot run it successfully now. I get this error:
Code:
root@server:mysql_install_db
Installing MySQL system tables...
121012 11:58:47 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
121012 11:58:47 [ERROR] Aborting
When I try to run it:
Code:
root@server:/var/lib/mysql# /etc/rc.d/rc.mysqld start
root@server:/var/lib/mysql# 121012 12:02:49 mysqld_safe Logging to '/var/lib/mysql/server.err'.
121012 12:02:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121012 12:02:52 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
Can somebody help me please?
 
Old 10-12-2012, 05:24 AM   #2
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,574

Rep: Reputation: 430Reputation: 430Reputation: 430Reputation: 430Reputation: 430
have a look on your /etc/my.cnf
replace '--skip-locking' with 'skip-external-locking'
 
1 members found this post helpful.
Old 10-14-2012, 10:00 AM   #3
Wed
Member
 
Registered: Sep 2005
Location: Sweden
Distribution: Slackware
Posts: 147

Rep: Reputation: 26
I have the exact same problem.

There is no such thing, in my freshly installed Slack 14 system, as /etc/my.cnf. In /etc/mysql/, there are a few my- small, medium, huge and so on files though.
 
Old 10-14-2012, 11:11 AM   #4
Alien Bob
Slackware Contributor
 
Registered: Sep 2005
Location: Eindhoven, The Netherlands
Distribution: Slackware
Posts: 5,305

Rep: Reputation: Disabled
Quote:
Originally Posted by Wed View Post
I have the exact same problem.

There is no such thing, in my freshly installed Slack 14 system, as /etc/my.cnf. In /etc/mysql/, there are a few my- small, medium, huge and so on files though.
It is up to you to use one of these example files and copy them to "/etc/mysql/my.cnf". Slackware does not install one by default.

Eric
 
Old 10-14-2012, 02:42 PM   #5
pitt30
Member
 
Registered: Jan 2004
Posts: 53

Rep: Reputation: 16
ha, yeah, doing the same thing today... trying to get mysql going and get rolling comments on the screen. checked log messages and see a mention of hard drive space. now i look at df -h and see root is 100% used. this is a new server and nothing installed. /usr has ~6 gig used. i just dont see where this space has gone???? but i cant start mysql till i clean this up


root@Slackbox:/# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 36G 35G 0 100% /
/dev/sdb1 459G 225G 211G 52% /vol1
/dev/sdc1 459G 47G 390G 11% /vol2
/dev/sdd1 37G 181M 35G 1% /home
/dev/sdd2 77G 281M 72G 1% /myvar
tmpfs 1.5G 0 1.5G 0% /dev/shm



root@Slackbox:/# ls | xargs du -hs
11M bin
26M boot
316K chroot
0 dev
15M etc
4.3M home
236M lib
16K lost+found
64K media
40K mnt
102M myvar
4.0K opt
du: cannot access 'proc/2183/task/2183/fd/3': No such file or directory
du: cannot access 'proc/2183/task/2183/fdinfo/3': No such file or directory
du: cannot access 'proc/2183/fd/3': No such file or directory
du: cannot access 'proc/2183/fdinfo/3': No such file or directory
0 proc
25M root
800K run
17M sbin
4.0K srv
0 sys
4.0M tmp
6.1G usr
225M var
225G vol1
46G vol2
 
Old 10-14-2012, 04:01 PM   #6
Alien Bob
Slackware Contributor
 
Registered: Sep 2005
Location: Eindhoven, The Netherlands
Distribution: Slackware
Posts: 5,305

Rep: Reputation: Disabled
Quote:
Originally Posted by pitt30 View Post
ha, yeah, doing the same thing today...
Do not hi-jack this thread please. Your problem has nothing to do with the question of the Original Poster.

Eric
 
Old 10-15-2012, 02:37 AM   #7
hua
Member
 
Registered: Oct 2006
Location: Slovak Republic
Distribution: Slackware 13.37, 14.0
Posts: 394

Original Poster
Rep: Reputation: 49
Sorry for the late answer.
My problem was in the old database files in /var/lib/mysql. I didn't really investigate what exactly was the problem for now, I just copied the whole directory to make a backup and deleted the content. (I needed to get it work quickly) After this the script worked fine.

Actually your suggestion willysr bypassed the error but I get another one which said something about mysql.proc error. At this point I was thinking that there is something wrong with the databases (tables) in /var/lib/mysql.
I bet that in upgrade instructions there are some notes about how to get the old databases to work after upgrade. My mistake was in the fact that I expected that these steps - removepkg mysql..., installpkg mysql... - going to remove everything what belongs to mysql. It didn't and it gives sense why not.

Thanks for your answers. Have a nice day.
 
Old 10-15-2012, 09:56 AM   #8
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,574

Rep: Reputation: 430Reputation: 430Reputation: 430Reputation: 430Reputation: 430
Yeah, there was a command to upgrade the mysql database manually and i did that, so i never run into that problem. I should have remembered that earlier. Sorry about that, but you can try have a look on the mysql package. I'm not in front of my computer for this week
 
  


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
[SOLVED] mysql_install_db fail tamtam Slackware 1 08-03-2010 01:08 AM
running mysql_install_db foampile Linux - Server 2 03-18-2009 10:38 AM
mysql - mysql_install_db (error) n0p.cracker Linux - Server 1 08-04-2008 12:23 PM
mysql mysql_install_db problems xrado Slackware 3 05-09-2006 01:10 AM
mysql_install_db hus Linux - Newbie 1 05-11-2005 12:33 AM


All times are GMT -5. The time now is 05:16 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration