| View previous topic :: View next topic |
| Author |
Message |
KePSuX
Guru
Joined: 29 Sep 2003
Posts: 312
Location: Fredericksburg Va
|
 Posted: Sun Jun 27, 2004 9:09 pm Post subject: MySQL error on start |
 |
|
Bear with me as I'm not very MySQL savvy. I have installed mysql 4.20 and when I run /etc/init.d/mysql start it is telling me
| Code: |
elvis mysql # /etc/init.d/mysql start
* WARNING: "mysql" has already been started.
|
the error log in /var/log/mysqld.err is :
| Code: |
040627 15:42:09 bdb: PANIC: No such file or directory
040627 15:42:09 Can't init databases
040627 15:42:09 Aborting
|
It's a pretty cryptic message, and I was hoping someone else has seen something like this. Any ideas of where to look, or is there more info I can submit for you folks to help me? Thanks as usual!
_________________
http://www.atomicraygunattack.com |
|
| Back to top |
|
 |
nitro322
Guru
Joined: 24 Jul 2002
Posts: 594
Location: USA
|
| Posted: Mon Jun 28, 2004 5:44 am Post subject: |
|
|
I can't give you any definite solutions, but here are a couple things you can try:
Try running '/etc/init.d/mysql zap', then '/etc/init.d/mysql start'. See if that tells you anything different.
Did you initialize the database after installation? If not, try running 'ebuild /var/db/pkg/dev-db/mysql-4.0.18-r2/mysql-4.0.18-r2.ebuild config'. Of course, be sure to change that command to match your installed version.
I've never seen that bdb error before. I'd suspect it has something to do with Berkekey DB support, though. If it still fails after trying the above two steps, try recompiling mysql without Berkeley DB support (-berkdb USE flag). Unless you know that you specifically need it, this shouldn't affect how you use MySQL at all. |
|
| Back to top |
|
|
Rav70
l33t
Joined: 11 Feb 2004
Posts: 607
Location: Poland
|
| Posted: Mon Jun 28, 2004 7:38 am Post subject: |
|
|
Did you create necessary tables using mysql_install_db?
_________________
Q: Why is Microsoft's Product Support a failure?
A: Because Microsoft needs a Support Group instead. |
|
| Back to top |
|
|
KePSuX
Guru
Joined: 29 Sep 2003
Posts: 312
Location: Fredericksburg Va
|
| Posted: Mon Jun 28, 2004 7:28 pm Post subject: |
|
|
Yeah, we tried using zap. Even after you manually set it to off, and try and start, it does the same thing.
But, I'm going to try and not compile for berkley DB.
Thank you.
_________________
http://www.atomicraygunattack.com |
|
| Back to top |
|
|
Raniz
l33t
Joined: 13 Sep 2003
Posts: 967
Location: Varberg, Sweden
|
| Posted: Mon Jun 28, 2004 7:30 pm Post subject: |
|
|
| Rav70 wrote: | | Did you create necessary tables using mysql_install_db? |
|
|
| Back to top |
|
|
KePSuX
Guru
Joined: 29 Sep 2003
Posts: 312
Location: Fredericksburg Va
|
| Posted: Tue Jun 29, 2004 4:41 am Post subject: |
|
|
| nitro322 wrote: |
I've never seen that bdb error before. I'd suspect it has something to do with Berkekey DB support, though. If it still fails after trying the above two steps, try recompiling mysql without Berkeley DB support (-berkdb USE flag). Unless you know that you specifically need it, this shouldn't affect how you use MySQL at all. |
| Code: |
emerge unmerge mysql
USE="-berkdb" emerge mysql
|
This worked. Thanks!!
_________________
http://www.atomicraygunattack.com |
|
| Back to top |
|
|
|
Other Things Gentoo
