Error 1016 during mysqldump

h725 · 03-30-2009, 02:50 AM

Hi,

I'm trying to backup all my mysql databases.
I'm using this string:

mysqldump -uroot --opt --all-databases -p > /root/mysqldump.sql

I've this error:

Enter password:
mysqldump: Got error: 1016: Can't open file: 'phpbb_sessions.MYI'. (errno: 145) when using LOCK TABLES

How can I solve this?
I need to "stop" all vhost that are using my mysql server? Or add some specific option?
Thank you

bathory · 03-30-2009, 04:26 AM

You can try adding the "--quick" option to see if it helps. Otherwise I'm afraid you have to shutdown at least the vhost running phpbb, before running mysqldump.

shijujoe · 08-17-2009, 04:58 AM

Try with --lock-tables=false in mysqldump syntax

eg: mysqldump dbname > dbname.sql -u root -p --lock-tables=false

Regards
Shiju V.Joseph
EY|Trivandrum