On Friday 28 Jan 2011 15:43:26 Per Jessen wrote:
Bob Williams wrote:
Check the mysqld log file - probably in /var/log/mysql/mysqld.log or /var/lib/mysql/mysqld.log
I would guess something isn't quite right in /etc/my.cnf
You're quite right. It didn't like the load-infile option (unknown) so it kept aborting.
If isn't a typo, that can only be because the mysqld binary was compiled without the option to enable load-infile.
OK, I'm only going to be creating small databases, so I can insert each record one by one.
You can also batch the INSERT statements in a file, and run them from stdin:
mysql
However, after removing the offending line from /etc/my.cnf, I still can't start the server. The last few lines of the mysqld.log say ...
110128 14:51:30 [ERROR] Plugin 'InnoDB' init function returned error. 110128 14:51:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
That is weird.
110128 14:51:30 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 110128 14:51:30 [ERROR] Do you already have another mysqld server running on port: 3306 ? 110128 14:51:30 [ERROR] Aborting
110128 14:51:30 [Note] /usr/sbin/mysqld: Shutdown complete
110128 14:51:30 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
but I can't see that there's another server instance running. If there was, I should be able to use it?
Almost certainly, yes. You can check if someone is already listening on port 3306: "netstat -ltn".
Also, "pidof mysqld" will tell you the pid if any running mysqld process.
Hurrah! Many thanks, Per, there were two pids. Killed both, server starts OK. I've learnt a lot, thank you for your patience. Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3 Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org