Cannot access MySql after OS upgrade
I had to upgrade my SGI server to operating system IRIX 6.5.18m from 6.5.15m after the upgrade I can access MySql from the command line but I cannot make an ODBC connection and my web pages using mysql do not work. Other than the OS upgrade no other changes were made. I have tried reinstalling the mysql software version 3.23.54a and it made no difference. My MySql log file has the following entries which show that it is starting fine: 030123 20:15:00 /usr/freeware/sbin/mysqld: Shutdown Complete 030123 20:15:00 mysqld ended 030123 20:31:54 mysqld started /usr/freeware/sbin/mysqld: ready for connections 030123 20:46:44 /usr/freeware/sbin/mysqld: Normal shutdown 030123 20:46:45 /usr/freeware/sbin/mysqld: Shutdown Complete 030123 20:46:45 mysqld ended 030123 20:47:51 mysqld started /usr/freeware/sbin/mysqld: ready for connections - 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
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/binsafe_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/mysqlmore 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