You are not logged in.

#1 2006-04-04 12:34:15

Insane-Boy
Member
Registered: 2006-02-27
Posts: 243

mysqld

[root@InSaNe DeViL]# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/InSaNe.pid
060404 15:36:10  mysqld ended

[root@InSaNe DeViL]#     

Why happend this ? I start the server but it stops by itself?The errorlog should help i think :
[DeViL@InSaNe ~]$ cat /var/lib/mysql/InSaNe.err
060404 17:39:59  mysqld started
060404 17:40:00  InnoDB: Started; log sequence number 0 43665
060404 17:40:00 [ERROR] bdb:  unable to initialize mutex: Function not implemented
060404 17:40:00 [ERROR] bdb:  process-private: unable to initialize environment lock: Function not implemented
060404 17:40:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
060404 17:40:00  mysqld ended

[DeViL@InSaNe ~]$

Offline

#2 2006-04-05 13:55:23

Insane-Boy
Member
Registered: 2006-02-27
Posts: 243

Re: mysqld

Any ideas?

Offline

#3 2006-04-05 20:09:06

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: mysqld

did  you start it the first time via /etc/rc.d/mysqld start ?
Seems like the db directory was not properly initialized or something.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#4 2006-04-05 20:46:58

Neuro
Member
From: Poland
Registered: 2005-10-12
Posts: 352

Re: mysqld

Well, I remember having some problems with mysqld, but it was a while ago on a Slack box.

It seems like the daemon is having problems creating/using database files found in /var/lib/mysql. First of all, check if they are owned by mysql/mysql and are rw- for owner and group. I'm not sure if the arrangement is the same as in Slackware, but I'm pretty sure that mysql is running as user mysql and group mysql.

Offline

#5 2006-04-06 07:34:42

kth5
Member
Registered: 2004-04-29
Posts: 657
Website

Re: mysqld

if you do not have files/data in /var/lib/mysql, the easiest way to recreate mysql would be to simply remove it or move it away, then restart mysql with /etc/rc.d/mysqld.

if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.

in any case, starting from scratch and importing a backup is always a way better idea! smile


I recognize that while theory and practice are, in theory, the same, they are, in practice, different. -Mark Mitchell

Offline

#6 2006-04-06 07:57:27

Moo-Crumpus
Member
From: Hessen / Germany
Registered: 2003-12-01
Posts: 1,487

Re: mysqld

This could be what you need:
http://bugs.archlinux.org/task/4096


Frumpus addict
[mu'.krum.pus], [frum.pus]

Offline

#7 2006-04-06 10:59:54

Insane-Boy
Member
Registered: 2006-02-27
Posts: 243

Re: mysqld

kth5 wrote:

if you do not have files/data in /var/lib/mysql, the easiest way to recreate mysql would be to simply remove it or move it away, then restart mysql with /etc/rc.d/mysqld.

if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.

in any case, starting from scratch and importing a backup is always a way better idea! smile

I tryied and all is fine now.For other with my problem : I removed my old /var/lib/mysql dir then i run mysql_install_db then I chowned /var/lib/mysql to mysql:mysql.That's all and thanks.

Offline

#8 2006-04-06 14:33:22

kth5
Member
Registered: 2004-04-29
Posts: 657
Website

Re: mysqld

Insane-Boy wrote:
kth5 wrote:

if you do not have files/data in /var/lib/mysql, the easiest way to recreate mysql would be to simply remove it or move it away, then restart mysql with /etc/rc.d/mysqld.

if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.

in any case, starting from scratch and importing a backup is always a way better idea! smile

I tryied and all is fine now.For other with my problem : I removed my old /var/lib/mysql dir then i run mysql_install_db then I chowned /var/lib/mysql to mysql:mysql.That's all and thanks.

that's exactly what /etc/rc.d/mysqld does when /var/lib/mysql does not exists btw.


I recognize that while theory and practice are, in theory, the same, they are, in practice, different. -Mark Mitchell

Offline

Board footer

Powered by FluxBB