I'm very much a mysql novice, but I've successfully built a couple of small databases here. Since upgrading to oS 12.3 + KDE 4.10, I've been unable to restart the mysql server. barrowhillfarm:~ # mysqld_safe 130329 17:15:09 mysqld_safe Logging to '/var/log/mysql/mysqld.log'. 130329 17:15:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130329 17:15:09 mysqld_safe mysqld from pid file /var/lib/mysql/barrowhillfarm.henfield.pid ended Following which /var/run/mysql is empty. I would expect to find mysql.sock. So, what does the log show ... 130329 17:16:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130329 17:16:08 [ERROR] mysqld: File './mysql-bin.index' not found (Errcode: 13) 130329 17:16:08 [ERROR] Aborting 130329 17:16:08 [Note] /usr/sbin/mysqld: Shutdown complete 130329 17:16:08 mysqld_safe mysqld from pid file /var/lib/mysql/barrowhillfarm.henfield.pid ended So, the problem appears to be a missing index file. However... barrowhillfarm:~ # ls -al /var/lib/mysql total 50296 drwxr-xr-x 8 root root 4096 Mar 29 17:16 . drwxr-xr-x 50 root root 4096 Mar 27 22:06 .. drwxr-xr-x 2 root root 4096 Mar 27 22:08 Joomla drwxr-xr-x 2 root root 4096 Mar 27 22:08 bbelle_Joomla drwxr-xr-x 2 root root 4096 Mar 27 22:08 bbsc_members_db drwxr-xr-x 2 root root 4096 Mar 27 22:08 firstthingsfirst -rw-r----- 1 root root 5242880 Mar 27 22:08 ib_logfile0 -rw-r----- 1 root root 5242880 Mar 27 22:08 ib_logfile1 -rw-r----- 1 root root 27262976 Mar 27 22:08 ibdata1 drwxr-xr-x 2 root root 4096 Mar 27 22:08 mysql -rw-r----- 1 root root 27807 Mar 27 22:08 mysql-bin.000001 -rw-r----- 1 root root 997144 Mar 27 22:08 mysql-bin.000002 . .[snipped similar entries] . -rw-r----- 1 root root 126 Mar 27 22:08 mysql-bin.000062 -rw-r----- 1 root root 126 Mar 27 22:08 mysql-bin.000063 -rw-r----- 1 root root 107 Mar 27 22:08 mysql-bin.000064 -rw-r----- 1 root root 1216 Mar 27 22:08 mysql-bin.index drwxr-xr-x 2 root root 4096 Mar 27 22:08 performance_schema ... so mysql-bin.index *does* exist. I tried removing mysql-bin.index to see if it would be recreated, but no luck :( I should say that the contents of /var/lib/mysql were restored from a backup after the upgrade, which was a new installation style of upgrade, rather than an upgrade in place, but I wouldn't think that would make a difference. I have not made any changes to /etc/my.cnf. I'm probably missing something really obvious, but I've run out of ideas. Bob -- Bob Williams System: Linux 3.7.10-1.1-desktop Distro: openSUSE 12.3 (x86_64) with KDE Development Platform: 4.10.1 "release 545" Uptime: 06:00am up 22:12, 3 users, load average: 0.10, 0.12, 0.13 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org