[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Wed, Jun 21, 2006 at 04:41:00PM +0100, Neil Winchurst wrote: > 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 At this stage mysql is running, your socket exists in /var/lib/mysql/mysql.sock, it shows up in "ps -ef" > 060620 15:19:09 [Note] /usr/sbin/mysqld: Normal shutdown Unfortunatly it doesnt stay up long > > 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 > It's complaining that it can't write to /root/tmp/ As said elsewhere, you don't need my.cnf if you go with the defaults mkdir /root/tmp should get you past this first stage. Also check that /var/lib/mysql exists and has files in. Sounds like the install didn't go to plan though, I've never used mandriva so I don't know what to suggest from a "nice" point of view. -- 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