Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql startup error after update (SOLVED)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
JC99
l33t
l33t


Joined: 06 Aug 2003
Posts: 782
Location: Toronto

PostPosted: Mon Jan 21, 2013 12:34 am    Post subject: mysql startup error after update (SOLVED) Reply with quote

Hi everyone,

I updated mysql today but received the following error when I tried to start it up...

Quote:
homebox ~ # /etc/init.d/mysql start
* Starting mysql ...
mkdir: cannot create directory '@GENTOO_PORTAGE_EPREFIX@/var/run/mysqld': No such file or directory
* Directory @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld for pidfile does not exist and cannot be created
* ERROR: mysql failed to start


Does anyone know what's wrong or how to get it working again?

Thanks


Last edited by JC99 on Mon Jan 21, 2013 8:21 pm; edited 1 time in total
Back to top
View user's profile Send private message
666threesixes666
Veteran
Veteran


Joined: 31 May 2011
Posts: 1225
Location: 42.68n 85.41w

PostPosted: Mon Jan 21, 2013 12:39 am    Post subject: Reply with quote

i suggest rolling back a version or two or going forward a version or two to get it up and running again quickly.

change your /etc/portage/package.accept_keyword
dev-db/mysql ~amd64

to move to latest... in my case.... (as im amd64)

or to move back like 6 versions

=dev-db/mysql-5.5.19 ~amd64

you can use porthole to see versions of packages available... (emerge porthole)

(moral of the story, write down the version you have that works before you move forward or backward so you can re-implement what was previously working)

after actually trying to implement my own suggestions.... i had to add the virtual to my /etc/portage/package.accept_keyword file...
dev-db/mysql ~amd64
virtual/mysql ~amd64

to move me to the absolute very latest mysql....

run....
ls /usr/portage/distfiles/ | grep mysql
to get hints as to what was installed......
Back to top
View user's profile Send private message
JC99
l33t
l33t


Joined: 06 Aug 2003
Posts: 782
Location: Toronto

PostPosted: Mon Jan 21, 2013 3:00 am    Post subject: Reply with quote

Thanks for the advice. I switched to 5.5.19 and it appears to be working fine now
Back to top
View user's profile Send private message
alexdu
n00b
n00b


Joined: 25 Oct 2005
Posts: 38
Location: Moscow, Russia

PostPosted: Mon Jan 21, 2013 10:00 am    Post subject: Reply with quote

someone can try this:
Code:
# sed -i -e 's/\@GENTOO_PORTAGE_EPREFIX\@//' /etc/mysql/my.cnf

or reboot and then re-emerge mysql.
Back to top
View user's profile Send private message
b3cks
Veteran
Veteran


Joined: 23 Mar 2004
Posts: 1481
Location: Bremen (GER)

PostPosted: Mon Jan 21, 2013 11:09 am    Post subject: Reply with quote

alexdu wrote:
someone can try this:
Code:
# sed -i -e 's/\@GENTOO_PORTAGE_EPREFIX\@//' /etc/mysql/my.cnf

or reboot and then re-emerge mysql.

Worked for me. Thanks a lot!
_________________
I am /root and if you see me laughing you better have a backup.
Back to top
View user's profile Send private message
jms.gentoo
n00b
n00b


Joined: 07 May 2009
Posts: 63

PostPosted: Mon Jan 21, 2013 2:39 pm    Post subject: Reply with quote

alexdu wrote:
someone can try this:
Code:
# sed -i -e 's/\@GENTOO_PORTAGE_EPREFIX\@//' /etc/mysql/my.cnf

or reboot and then re-emerge mysql.


worked for me too...
Code:

# sed -i -e 's/\@GENTOO_PORTAGE_EPREFIX\@//' /etc/mysql/my.cnf
# /etc/init.d/mysql restart

Back to top
View user's profile Send private message
JC99
l33t
l33t


Joined: 06 Aug 2003
Posts: 782
Location: Toronto

PostPosted: Mon Jan 21, 2013 8:20 pm    Post subject: Reply with quote

Ran into another problem after upgrading to mysql 5.5.19 so I downgraded to 5.1.67 and ran that command and everything is working now. Thanks alexdu.
Back to top
View user's profile Send private message
666threesixes666
Veteran
Veteran


Joined: 31 May 2011
Posts: 1225
Location: 42.68n 85.41w

PostPosted: Mon Jan 21, 2013 9:41 pm    Post subject: Reply with quote

mysql-5.1.62.tar.gz is what i found on my system before i upgraded to mysql-5.5.28.tar.gz i know the 5.5.28 is having problems with its setup, but im a laptop, not an industrial production server wasting millions of dollars by the second.... exactly why i phrased the original post as i did..... good luck and hope everythings working well for you again....
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum