Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 30th, 2003, 08:44 AM
Registered User
 
Join Date: Jul 2003
Location: Mumbai, Maharashtra, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysqld dies immediately after startup

I want to build Web Site with apache, mysql & php. I have installed Red Hat 8 on pentium 4 system. After downloading source code for all the three packages I have compiled Apache,PHP,MySql. The compilation completed without any errors.

Now when I try to run /etc/rc.d/init.d/mysql start

I am geting following message

Starting mysqld daemon with databases from /usr/local/mysql/var
030730 19:08:31 mysqld ended

When I checked localhost.localdomain.err file from /usr/mysql/var
it is showning following error message

030730 19:08:30 mysqld started
030730 19:08:31 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
030730 19:08:31 InnoDB: Flushing modified pages from the buffer pool...
030730 19:08:31 InnoDB: Started
030730 19:08:31 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030730 19:08:31 mysqld ended

As I am compiling these software first time I don't have any clue about how to solve these types of problems. Please help me out!
I am using a book "beginning databases with MySQL" to learn these softwares.

Thanks in advance

Prasad Sakharkar
Mumbai(India)
getpas@rediffmail.com



Reply With Quote
  #2 (permalink)  
Old September 3rd, 2003, 06:20 PM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to merediths
Default


getpas,

 I don't have a working install of mysql server where I'm at now, so this is based on memory.

 If all you did was build the binaries on your system you are missing a critical step -- the mysql needs to find it's conf database where it expects to start correctly. I've run into this issue myself (with a similiar sounding error message). Inside the build directory their should be a sub-tree named 'scripts' or 'sql' or something to that effect -- after building the binaries you need to run these scripts to create the initial database mysql needs to run. If you don't, you will get that error message.

  Also, the build process could have dumped them somewhere that mysql doesn't expect ... for example, in /usr/local/var instead of /usr/local/mysql/var ... if you build the database ( see above paragraph) and still get the same error message, check if there are any mysql files, or a mysql folder under /usr/local/var and, if so, try creating sym-links to /usr/local/mysql/var ( or where ever the error msg indicates mysql is looking ).

 The specifics should be documented in the mysql installation guide or pdf manual.

Regards,
Meredith Shaebanyan

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
current changes are not saving immediately venkys C# 1 January 27th, 2006 11:01 AM
Session expires immediately codebuyer Classic ASP Components 6 March 18th, 2005 12:54 PM
.NET Remoting , If a .NETter dies in a channel... nds2000 Pro VB.NET 2002/2003 0 December 11th, 2003 04:00 PM
Please Respond immediately sainaidu SQL Server 2000 2 August 10th, 2003 08:25 AM



All times are GMT -4. The time now is 12:27 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.