Mysqldump error in VPS

[jolly]

I am getting error whenever I try to dump mysql on VPS

[[email protected] init.d]# mysqldump -u root -p megablog_mega > megablog_blog.sql
> Enter password:
> mysqldump: Got error: 1017: Can't find file:
> './megablog_mega/wp_63_post2cat.frm' (errno: 24) when using LOCK TABLES

All resources on VPS are set to unlimited.
Thanks

 

[jayh38]

Try something like this and throw it in a gz if desired.

/usr/bin/mysqldump --opt -Q user | gzip > /home/destination/filename.gz

 

[speckados]

This problem it's because database it's very large on tables, and --lock can't open files that it needs.

try mysqldump without --lock-tables

mysqldump --lock-tables=false --add-drop-table --add-locks --create-options --disable-keys --extended-insert  --quick --set-charset [database] > [database].sql