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.
--
Per Jessen, Zürich (0.2°C)
--
To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org
For additional commands, e-mail: opensuse+help@opensuse.org