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 …
Showing entries 1 to 1
Jul
16
2014
Showing entries 1 to 1