List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 1 2011 10:55am
Subject:Re: Not finding my.cnf file
View as plain text  
Check the permissions in the datadir.

On Wed, Jun 1, 2011 at 11:50 AM, Adarsh Sharma <adarsh.sharma@stripped>wrote:

> Thanks, It works & a new error occurs as :
>
> 110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from
> /hdd2-1/myisam_data
> /usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index' not found
> (Errcode: 13)
> 110601 16:16:16 [ERROR] Aborting
>
> 110601 16:16:16 [Note] /usr/sbin/mysqld: Shutdown complete
>
> I checked & /hdd2-1/myisam_data/mysql-bin.index file is there , how to
> comes
> Thanks
>
>
> Peter Boros wrote:
>
>> Hi,
>>
>> You probably didn't run mysql_install_db.
>>
>> Peter Boros
>>
>> On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
>>
>>
>>> I got the error after setting my.cnf file in /etc directory.
>>>
>>> 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
>>> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
>>>
>>> After some research i found the cause of this error : the new my.cnf
>>> is very old and mysql_upgrade is needed
>>>
>>> So , Can someone Please give my a standard my.cnf file that contains
>>> all the parameters.
>>>
>>> Is my.cnf file is different for different versions.
>>> My mysql version is 5.1.4. Please check my attached my.cnf file
>>>
>>> Thanks
>>>
>>> John Daisley wrote:
>>>
>>>> I think the default location on Centos is /etc/my.cnf
>>>>
>>>> Regards
>>>> John
>>>>
>>>> On 1 June 2011 10:24, Adarsh Sharma <adarsh.sharma@stripped>
> wrote:
>>>>
>>>>
>>>>
>>>>> Dear all,
>>>>>
>>>>> I install mysql in CentOS -5.4 through 2 commands :
>>>>>
>>>>> yum install mysql-server
>>>>> yum install mysql-client
>>>>>
>>>>> And I can see directories created in /var/lib/mysql directory.
>>>>>
>>>>> But now i want to change it to my /hdd1-1 diretcory and alse set
>>>>> logging
>>>>> directories.
>>>>> So , I search my.cnf file as:
>>>>>
>>>>> [root@ws-test ~]# find / -name my.cnf
>>>>> [root@ws-test ~]#
>>>>>
>>>>> Now how could I solve this issue & from where mysql picks its
>>>>> configuration
>>>>> or it go for its default.
>>>>>
>>>>>
>>>>> Thanks & best Regards,
>>>>> Adarsh Sharma
>>>>>
>>>>> --
>>>>> MySQL General Mailing List
>>>>> For list archives: http://lists.mysql.com/mysql
>>>>> To unsubscribe:
>>>>> http://lists.mysql.com/mysql?unsub=1
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>> plain text document attachment (my.cnf)
>>> #This is for a large system with memory = 512M where the system runs
>>> mainly
>>> # MySQL.
>>> #
>>> # You can copy this file to
>>> # /etc/my.cnf to set global options,
>>> # mysql-data-dir/my.cnf to set server-specific options (in this
>>> # installation this directory is @localstatedir@) or
>>> # ~/.my.cnf to set user-specific options.
>>> #
>>> # In this file, you can use all long options that a program supports.
>>> # If you want to know which options a program supports, run the program
>>> # with the "--help" option.
>>>
>>> # The following options will be passed to all MySQL clients
>>>
>>> [client]
>>> #password = your_password
>>> port  = 3306
>>> socket  = /var/lib/mysql/mysql.sock
>>>
>>> # Here follows entries for some specific programs
>>> # The MySQL server
>>> [mysqld]
>>> port  = 3306
>>> socket  = /var/lib/mysql/mysql.sock
>>> #skip-locking
>>>
>>> # Caches and Buffer Sizes
>>> key_buffer = 256M
>>> max_allowed_packet=16M
>>> table_cache = 256
>>> sort_buffer_size = 2M
>>> read_buffer_size = 2M
>>> read_rnd_buffer_size = 4M
>>>
>>> #record_buffer = 1M
>>>
>>> myisam_sort_buffer_size = 128M
>>> thread_cache = 128
>>> query_cache_limit = 2M
>>> query_cache_type = 1
>>> query_cache_size = 32M
>>> key_buffer = 16M
>>> join_buffer = 2M
>>> table_cache = 1024
>>>
>>> datadir = /hdd2-1/myisam_data
>>>
>>> log-bin=mysql-bin
>>>
>>> #Time Outs
>>> interactive_timeout = 100
>>> wait_timeout = 100
>>> connect_timeout = 10
>>>
>>> # Try number of CPU's*2 for thread_concurrency
>>> thread_concurrency = 2
>>>
>>> # Maximum connections allowed
>>> max_connections = 100
>>> max_user_connections = 50
>>> max_connect_errors = 10
>>>
>>> # Don't listen on a TCP/IP port at all. This can be a security
>>> enhancement,
>>> # if all processes that need to connect to mysqld run on the same host.
>>> # All interaction with mysqld must be made via Unix sockets or named
>>> pipes.
>>> # Note that using this option without enabling named pipes on Windows
>>> # (via the "enable-named-pipe" option) will render mysqld useless!
>>> #
>>> #skip-networking
>>>
>>> # Replication Master Server (default)
>>> # binary logging is required for replication
>>>
>>> # required unique id between 1 and 2^32 - 1
>>> # defaults to 1 if master-host is not set
>>> # but will not function as a master if omitted
>>> server-id = 1
>>>
>>> # Replication Slave (comment out master section to use this)
>>> #
>>> # To configure this host as a replication slave, you can choose between
>>> # two methods :
>>> #
>>> # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
>>> #    the syntax is:
>>> #
>>> #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
>>> #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
>>> #
>>> #    where you replace <host>, <user>, <password> by quoted
> strings and
>>> #    <port> by the master's port number (3306 by default).
>>> #
>>> #    Example:
>>> #
>>> #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
>>> #    MASTER_USER='joe', MASTER_PASSWORD='secret';
>>> #
>>> # OR
>>> #
>>> # 2) Set the variables below. However, in case you choose this method,
>>> then
>>> #    start replication for the first time (even unsuccessfully, for
>>> example
>>> #    if you mistyped the password in master-password and the slave fails
>>> to
>>> #    connect), the slave will create a master.info file, and any later
>>> #    change in this file to the variables' values below will be ignored
>>> and
>>> #    overridden by the content of the master.info file, unless you
>>> shutdown
>>> #    the slave server, delete master.info and restart the slaver server.
>>> #    For that reason, you may want to leave the lines below untouched
>>> #    (commented) and instead use CHANGE MASTER TO (see above)
>>> #
>>> # required unique id between 2 and 2^32 - 1
>>> # (and different from the master)
>>> # defaults to 2 if master-host is set
>>> # but will not function as a slave if omitted
>>> #server-id      = 2
>>> #
>>> # The replication master for this slave - required
>>> #master-host    =  <hostname>
>>> #
>>> # The username the slave will use for authentication when connecting
>>> # to the master - required
>>> #master-user    =  <username>
>>> #
>>> # The password the slave will authenticate with when connecting to
>>> # the master - required
>>> #master-password =  <password>
>>> #
>>> # The port the master is listening on.
>>> # optional - defaults to 3306
>>> #master-port    =  <port>
>>> #
>>> # binary logging - not required for slaves, but recommended
>>> #log-bin
>>>
>>> # Point the following paths to different dedicated disks
>>> #tmpdir  = /tmp/ #log-update  = /path-to-dedicated-directory/hostname
>>>
>>> # Uncomment the following if you are using BDB tables
>>> #bdb_cache_size = 64M
>>> #bdb_max_lock = 100000
>>>
>>> # Uncomment the following if you are using InnoDB tables
>>> innodb_data_home_dir = /var/lib/mysql/
>>> innodb_data_file_path = ibdata1:10M:autoextend
>>> innodb_log_group_home_dir = /var/log/innodblogs/
>>> #innodb_log_arch_dir = /var/log/innodblogsarchive/
>>>
>>> # You can set .._buffer_pool_size up to 50 - 80 %
>>> # of RAM but beware of setting memory usage too high
>>> innodb_buffer_pool_size = 4096M
>>> innodb_additional_mem_pool_size = 20M
>>> # Set .._log_file_size to 25 % of buffer pool size
>>> innodb_log_file_size = 40M
>>> innodb_log_buffer_size = 8M
>>> innodb_flush_log_at_trx_commit = 1
>>> innodb_lock_wait_timeout = 50
>>>
>>> [mysqldump]
>>> quick
>>> max_allowed_packet = 16M
>>>
>>> [safe_mysqld]
>>> err-log=/var/log/mysqld.log
>>> pid-file=/var/lib/mysql/mysql.pid <-- Not necessary
>>> open_files_limit=8192
>>>
>>>
>>> [mysql]
>>> no-auto-rehash
>>> # Remove the next comment character if you are not familiar with SQL
>>> #safe-updates
>>>
>>> [isamchk]
>>> key_buffer = 128M
>>> sort_buffer_size = 128M
>>> read_buffer = 2M
>>> write_buffer = 2M
>>>
>>> [myisamchk]
>>> key_buffer = 128M
>>> sort_buffer_size = 128M
>>> read_buffer = 2M
>>> write_buffer = 2M
>>>
>>> [mysqlhotcopy]
>>> interactive-timeout/log
>>> #-----------------------------------------
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>>
>>>
>>
>>
>>
>>
>>
>
>

Thread
Not finding my.cnf fileAdarsh Sharma1 Jun
  • Re: Not finding my.cnf fileAndrew Moore1 Jun
  • Re: Not finding my.cnf fileJohn Daisley1 Jun
    • Re: Not finding my.cnf fileAdarsh Sharma1 Jun
      • Re: Not finding my.cnf filePeter Boros1 Jun
        • Re: Not finding my.cnf fileAdarsh Sharma1 Jun
          • Re: Not finding my.cnf fileAndrew Moore1 Jun