| View previous topic :: View next topic |
| Author |
Message |
Evileye
l33t
Joined: 06 Aug 2003
Posts: 782
Location: Toronto
|
 Posted: Mon Jan 21, 2013 12:34 am Post subject: mysql startup error after update (SOLVED) |
 |
|
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 Evileye on Mon Jan 21, 2013 8:21 pm; edited 1 time in total |
|
| Back to top |
|
 |
666threesixes666
Veteran
Joined: 31 May 2011
Posts: 1248
Location: 42.68n 85.41w
|
| Posted: Mon Jan 21, 2013 12:39 am Post subject: |
|
|
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 |
|
|
Evileye
l33t
Joined: 06 Aug 2003
Posts: 782
Location: Toronto
|
| Posted: Mon Jan 21, 2013 3:00 am Post subject: |
|
|
| Thanks for the advice. I switched to 5.5.19 and it appears to be working fine now |
|
| Back to top |
|
|
alexdu
n00b
Joined: 25 Oct 2005
Posts: 49
Location: Moscow, Russia
|
| Posted: Mon Jan 21, 2013 10:00 am Post subject: |
|
|
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 |
|
|
b3cks
Veteran
Joined: 23 Mar 2004
Posts: 1481
Location: Bremen (GER)
|
| Posted: Mon Jan 21, 2013 11:09 am Post subject: |
|
|
| 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 |
|
|
jms.gentoo
Tux's lil' helper
Joined: 07 May 2009
Posts: 98
|
| Posted: Mon Jan 21, 2013 2:39 pm Post subject: |
|
|
| 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 |
|
|
Evileye
l33t
Joined: 06 Aug 2003
Posts: 782
Location: Toronto
|
| Posted: Mon Jan 21, 2013 8:20 pm Post subject: |
|
|
| 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 |
|
|
666threesixes666
Veteran
Joined: 31 May 2011
Posts: 1248
Location: 42.68n 85.41w
|
| Posted: Mon Jan 21, 2013 9:41 pm Post subject: |
|
|
| 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 |
|
|
|
Networking & Security
