LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-30-2003, 04:49 PM   #1
madfitz
LQ Newbie
 
Registered: Sep 2002
Posts: 15

Rep: Reputation: 0
Question ok... narrowed the problem down


I'm working on setting up mysql server using version 3.23 and it works for the default directory of the data... however it will not startup if I change the directory even if I change the owner & permissions to the exact same as default
owner & group are mysql & permissions are rwxr-xrwx for the new data directory.
the /etc/my.cnf config file was setting:
[mysqld]
datadir = /abc2/db

but every time the server is started it stops. I've checked the error log that appears in the directory I created.
--------------------------------------------------

030630 15:35:05 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
030630 15:35:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030630 15:35:05 mysqld ended

---------------------------------------
I thought for a while maybe it was a problem because it wanted to default to InnoDB tables so I set the datapath in that section of settings to also point to the same location and I still got the same problem.

If anyone knows why this is happening please, let me know or let me know if there's a really good mysql forum I should post to.

Thanks
 
Old 06-30-2003, 06:32 PM   #2
akaBeaVis
LQ Guru
 
Registered: Apr 2003
Location: Maryland
Distribution: Slack 9.1,10 Mandrake 10,10.1, FedCore 2,3, Mepis 2004, Knoppix 3.6,3.7, SuSE 9.1, FreeBSD 5.2
Posts: 1,109

Rep: Reputation: 45
try this:
http://forums.devshed.com/f4/s.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
perl problem? apache problem? cgi problem? WorldBuilder Linux - Software 1 09-17-2003 08:45 PM


All times are GMT -5. The time now is 10:53 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration