*SOLVED* Mysql dump error in VPS [message #7304] |
Tue, 10 October 2006 16:58 ![Go to next message Go to next message](/theme/ovz3/images/down.png) |
whatever
Messages: 142 Registered: September 2006
|
Senior Member |
|
|
I am getting error whenever I try to dump mysql on VPS
[root@99 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.
[Updated on: Wed, 11 October 2006 08:12] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Mysql dump error in VPS [message #7329 is a reply to message #7304] |
Wed, 11 October 2006 08:11 ![Go to previous message Go to previous message](/theme/ovz3/images/up.png) ![Go to next message Go to next message](/theme/ovz3/images/down.png) |
dev
Messages: 1693 Registered: September 2005 Location: Moscow
|
Senior Member |
![5072133](/theme/ovz3/images/icq.png)
|
|
Not all the resources are set unlimited.
You have ulimit for files = 1024:
[root@v1 ~]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 16317
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
So mysqld can't open more than 1024 files.
To fix it you need to run /usr/bin/mysqld_safe with --open-files-limit argument or
or specify
open-files-limit=4096
in /etc/my.cnf
But you added open_files_limit, not open-files-limit.
|
|
|
|
|
|
|