Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 06-30-2003, 03:49 PM   #1
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:
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
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
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.

Old 06-30-2003, 05:32 PM   #2
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:


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 07:45 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:44 PM.

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