Check the permissions in the datadir. On Wed, Jun 1, 2011 at 11:50 AM, Adarsh Sharma <adarsh.sha...@orkash.com>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.sha...@orkash.com> 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=john.dais...@butterflysystems.co.uk >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> 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=pe...@petya.org.hu >>> >>> >> >> >> >> >> > >
