So today I happen to need to restore a MySQL database from
backups so I could recover some tables. While I left he
production database running via port 3306, I set up the backup
via port 3307.
However, when I attempted to start another version via the 3307
port in a mysql_restore directory but I ran into some
errors....
/usr/bin/mysqld_safe --defaults-file=/etc/my_3307.cnf
[Warning] Can't create test file
/var/lib/mysql_restore/localhost.lower-test
[Warning] Can't create test file
/var/lib/mysql_restore/localhost.lower-test
Can't find file: './mysql/plugin.frm' (errno: 13)
InnoDB: Completed initialization of buffer pool
InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights
to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation …
Debian Linux (the underlying foundation of Ubuntu) manages the
startup/shutdown of MySQL quite differently from the ways I am
used to. I am a long-time user of both the MySQL binary provided
by Red Hat/SuSE (along with Fedora and clones like CentOS and
Oracle Enterprise Linux) and the official binary from mysql.com. After the
successful restore of a cold backup, I started
mysqld using the Debian provided init script. The
script said that mysqld failed to start up, but in
reality it did start up. Similarly, stopping mysqld
fails.
The output below demonstrates the outputs and the behavior seen on a Ubuntu 8.04 LTS Server:
root:~# ps -ef | grep mysqld root 20165 19926 0 15:12 pts/4 00:00:00 grep mysqld root:~# /etc/init.d/mysql start * Starting MySQL database server mysqld [fail] root:~# ps -ef | grep …[Read more]
Last year, Erik Ljungstrom (sensei in the #ourdelta IRC channel on Freenode) created patch for a bug Arjen identified with the handling of (among others) the open-files-limit option; the patch was first included in the OurDelta build of MySQL 5.0.67.
Now, Sun engineer Guilhem Bichot has committed the (modified) patch into the 6.0-maria tree, so it should appear in 6.0 and potentially 5.4. That’s good.
See http://bugs.mysql.com/40368 for details and history.