This is the second step and before that we have to stop the server and set the
parameter in my.cnf
innodb_data_home_dir =
innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw
and when i restart the server it is giving error
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]"
----- Original Message -----
From: Suresh Kuna
To: Jeetendra Ranjan
Cc: mysql@lists.mysql.com
Sent: Monday, January 04, 2010 12:45 PM
Subject: Re: innodb_data_file_path
Try this : /dev/sda3:10Graw;/dev/sda1:5Graw
Change the newraw to raw and start the MySQL.
and paste the error log ouput.
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan
<jeetendra.ran...@sampatti.com> wrote:
Hi Suresh,
Thanks, this link we already have but it has no information right from
creating the raw disk partition.
Jeetendra Ranjan
----- Original Message -----
From: Suresh Kuna
To: Jeetendra Ranjan
Cc: mysql@lists.mysql.com
Sent: Monday, January 04, 2010 12:12 PM
Subject: Re: innodb_data_file_path
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 <sureshkumar...@gmail.com>
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.ran...@sampatti.com> 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
To: Jeetendra Ranjan
Cc: mysql@lists.mysql.com
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.ran...@sampatti.com> 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=sureshkumar...@gmail.com
--
Thanks,
Suresh Kuna
--
Thanks
Suresh Kuna
MySQL DBA
--
Thanks
Suresh Kuna
MySQL DBA
--
Thanks
Suresh Kuna
MySQL DBA
