List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 4 2010 5:36am
Subject:Re: innodb_data_file_path
View as plain text  
Jeetendra,

Give the MySQLD user permissions to the new directory which you are
specifying.



On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan <
jeetendra.ranjan@stripped> wrote:

>  Hi Suresh,
>
> The error log show the related error as below
>
>
> InnoDB: File name /dev/sda3
> InnoDB: File operation call: 'open'.
> InnoDB: Cannot continue operation.
> 100102  1:18:32 [Warning] No argument was provided to --log-bin, and
> --log-bin-index was not used; so replication may break when this MySQL
> server acts as a master and has his hostname changed!! Please use
> '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem.
> 100102  1:18:32  InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
>
>
> Thanks
> Jeetendra Ranjan
>
>
>
> ----- Original Message -----
> *From:* Suresh Kuna <sureshkumarilu@stripped>
> *To:* Jeetendra Ranjan <jeetendra.ranjan@stripped>
> *Cc:* mysql@stripped
> *Sent:* Monday, January 04, 2010 10:28 AM
> *Subject:* Re: innodb_data_file_path
>
> Hi Jeetendra,
> What is the error it it saying in error log ?
> Is this the fresh installation or already installed MySQL ?
>
> Thanks
> Suresh Kuna
> MySQL DBA
>
> On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan <
> jeetendra.ranjan@stripped> wrote:
>
>> Hi,
>>
>> I am using MySQL 5.0.85-community on Fedora 8.
>>
>> When i set
>> innodb_data_home_dir =
>> innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw
>> and restart the server it gives an error
>>
>> "Starting MySQL.Manager of pid-file quit without updating file.[FAILED]"
>>
>> Please suggest how to resolve this issue ?
>>
>>
>> Thanks
>> Jeetendra Ranjan
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
> --
> Thanks,
> Suresh Kuna
>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
innodb_data_file_pathJeetendra Ranjan4 Jan
  • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
    • Re: innodb_data_file_pathSuresh Kuna4 Jan
      • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan
    • Re: innodb_data_file_pathSuresh Kuna4 Jan
  • Re: innodb_data_file_pathJeetendra Ranjan4 Jan