If you check the MySQL reference guide, you'll see that the Errorcode 13 is indicating that you don't have your permissions set up correctly for your data and log directories. Once you fix that, you should (hopefully) be okay.
David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -----Original Message----- From: Chamlee, Douglas, B. (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 11:38 AM To: '[EMAIL PROTECTED]' Subject: HELP for "mysql ended" error I am trying to upgrade the mysql database. I am installing on a Unix (SGI's IRIX) platform, upgrading to 3.23.52. I am installing a tar distribution (binary) from SGI's freeware web site. The installation goes fine - no errors - execpt when I try to start mysql it returns "mysql ended" and will not start. If there are any mysql pro's out there that could help I would really, really, really appreciate it. Thanks When I try to start mysql I get the following error at the command line: [62]<my_server_name:/usr/freeware/bin>safe_mysqld Starting mysqld daemon with databases from /local/mysql 021231 10:06:19 mysqld ended This is the output from my .err file from mysql: [84]server1.bliss.army.mil :/local/mysql>more server1.bliss.army.mil.err 021231 09:51:09 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:09 Could not use server1-bin for logging (error 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:09 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 09:51:09 mysqld ended 021231 09:51:50 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:50 Could not use doe1-bin for logging (error 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:50 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/doe1.bliss.army.mil.pid' (Errcode: 2) 021231 9:51:50 /usr/freeware/sbin/mysqld021231 09:51:50 mysqld ended 021231 09:57:06 mysqld started /usr/freeware/sbin/mysqld: Too many parameters /usr/freeware/sbin/mysqld Ver 3.23.52 for sgi-irix6.5 on mips Use '--help' or '--no-defaults --help' for a list of available options 021231 09:57:06 mysqld ended 021231 10:05:01 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:02 mysqld ended 021231 10:05:24 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:24 mysqld ended [85]server1.bliss.army.mil :/local/mysql>!! more server1.bliss.army.mil.err 021231 09:51:09 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:09 Could not use sever1-bin for logging (error 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:09 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 09:51:09 mysqld ended 021231 09:51:50 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:50 Could not use server1-bin for logging (error 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:50 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 9:51:50 /usr/freeware/sbin/mysqld021231 09:51:50 mysqld ended 021231 09:57:06 mysqld started /usr/freeware/sbin/mysqld: Too many parameters /usr/freeware/sbin/mysqld Ver 3.23.52 for sgi-irix6.5 on mips Use '--help' or '--no-defaults --help' for a list of available options 021231 09:57:06 mysqld ended 021231 10:05:01 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:02 mysqld ended 021231 10:05:24 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:24 mysqld ended 021231 10:06:19 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 10:06:19 Could not use server1-bin for logging (error 13) 021231 10:06:19 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 10:06:19 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 10:06:19 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 10:06:19 /usr/freeware/sbin/mysqld: Normal shutdown 021231 10:06:19 mysqld ended These are the settings in my.cnf config file for mysql: # Example mysql config file for large systems. # # This is for 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 /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] datadir = /local/mysql #basedir = /usr/freeware/bin port = 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 log-bin server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=100000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/var/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/var/ #innodb_log_arch_dir = /usr/local/mysql/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #set-variable = innodb_buffer_pool_size=256M #set-variable = innodb_additional_mem_pool_size=20M # Set .._log_file_size to 25 % of buffer pool size #set-variable = innodb_log_file_size=64M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #set-variable = innodb_lock_wait_timeout=50 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
