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
