jolly

Member
Dec 5, 2002
20
0
151
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

Well-Known Member
Mar 3, 2006
1,213
0
166
Try something like this and throw it in a gz if desired.

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

speckados

Well-Known Member
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

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