List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 4 2010 6:42am
Subject:Re: innodb_data_file_path
View as plain text  
Hi Jeetendra,
Check the below url for details with the raw partition.
http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html

Thanks
Suresh Kuna
MySQL DBA

On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna <sureshkumarilu@stripped>wrote:

> 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
>



-- 
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