Data Matters

We may copy the files under /var/lib/mysql when migrating Mysql tables. But we may get following erros in mysql client: mysql> select * from test; ERROR 1017 (HY000): Can't find file: './testdb/test.frm' (errno: 13) This is the issue of permission, you need to: sudo chown -R mysql.mysql /var/server/mysql/testdb/