[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Wed, 21 Jun 2006 10:43:42 +0100 James Fidell <james@xxxxxxxxxxxx> wrote: > > mysql will run quite happily without a my.cnf file, using the > compiled-in defaults for pathnames etc. > > It appears that for some reason the mysql daemon is exiting after > start-up, which might explain why you don't see the socket when you > need it. I'd expect to find something in /var/log/mysql*, > /var/lib/mysql/*.err or somewhere similar that might explain the > reason for the daemon failing to run correctly. > > James I have looked at the mysqld.log in /var/log/mysqld and here is the last set of information > 060620 15:19:06 mysqld started InnoDB: Resetting space id's in the doublewrite buffer 060620 15:19:06 InnoDB: Started; log sequence number 0 43912 InnoDB: You are upgrading to an InnoDB version which allows multiple InnoDB: tablespaces. Wait that purge and insert buffer merge run to InnoDB: completion... InnoDB: Full purge and insert buffer merge completed. InnoDB: You have now successfully upgraded to the multiple tablespaces InnoDB: format. You should NOT DOWNGRADE to an earlier version of InnoDB: InnoDB! But if you absolutely need to downgrade, see InnoDB: http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html InnoDB: for instructions. /usr/sbin/mysqld: ready for connections. Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 0 Source distribution 060620 15:19:09 [Note] /usr/sbin/mysqld: Normal shutdown 060620 15:19:10 InnoDB: Starting shutdown... 060620 15:19:12 InnoDB: Shutdown completed; log sequence number 0 43922 060620 15:19:12 [Note] /usr/sbin/mysqld: Shutdown complete 060620 15:19:12 mysqld ended 060620 15:30:25 mysqld started /usr/sbin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13) /usr/sbin/mysqld: Can't create/write to file '/root/tmp/ib5rOHux' (Errcode: 13) 060620 15:30:25 InnoDB: Error: unable to create temporary file; errno: 13 060620 15:30:25 [ERROR] Can't init databases 060620 15:30:25 [ERROR] Aborting 060620 15:30:25 [Note] /usr/sbin/mysqld: Shutdown complete 060620 15:30:25 mysqld ended So it tries to start and then shutsdown straight away. Does this make any sense to anyone? Neil Winchurst > -- > The Mailing List for the Devon & Cornwall LUG > http://mailman.dclug.org.uk/listinfo/list > FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html