OpenVZ Forum - RDF feed
type: channel
items: *SOLVED* Mysql dump error in VPS
items: Re: Mysql dump error in VPS

*SOLVED* Mysql dump error in VPS
type: item
description: 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.
creator: whatever
date: 2006-10-10T16:58:54-00:00

Re: Mysql dump error in VPS
type: item
description: Hi whatever, please post your my.conf esp. the value of "open-files-limit", may you set it to to a higher value. Regards, Thorsten
creator: curx
date: 2006-10-11T01:51:37-00:00

Re: Mysql dump error in VPS
type: item
description: #define EMFILE 24 /* Too many open files */ it is either mysql config or UBC settings.
creator: dev
date: 2006-10-11T04:54:40-00:00

Re: Mysql dump error in VPS
type: item
description: Hello /etc/my.cnf is blank there are no values my.cnf details [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -------------------------------------------- how can I increase value in my.cnf or UBC for the same. Thanks
creator: whatever
date: 2006-10-11T05:03:51-00:00

Re: Mysql dump error in VPS
type: item
description: ok, let's do the following: in VE: # cat /proc/user_beancounters > bc1 # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql # cat /proc/user_beancounters > bc2 and send me files bc1, bc2, out after that.
creator: dev
date: 2006-10-11T05:30:57-00:00

Re: Mysql dump error in VPS
type: item
description: dev wrote on Wed, 11 October 2006 01:30 ok, let's do the following: in VE: # cat /proc/user_beancounters > bc1 # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql # cat /proc/user_beancounters > bc2 and send me files bc1, bc2, out after that. ---------------------------------------------- # cat /proc/user_beancounters > bc1 # cat /proc/user_beancounters > bc2 No output --------------------------------------------------------- # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql mysqldump: Got error: 1105: File './megablog_mega/wp_43_categories.MYD' not found (Errcode: 24) when using LOCK TABLES ----------------------------------------------------------
creator: whatever
date: 2006-10-11T05:42:00-00:00

Re: Mysql dump error in VPS
type: item
description: I see only one of 3 files requested. files: bc1, bc2, out. BTW, small mistake, run mysql-dump as: # strace -f -o out mysqldump -u root -p megablog_mega > megablog_blog.sql
creator: dev
date: 2006-10-11T05:53:33-00:00

Re: Mysql dump error in VPS
type: item
description: I gave output of three files you requested I give again 1. # cat /proc/user_beancounters > bc1 No output 2. # cat /proc/user_beancounters > bc2 No output 3. # strace -f -o out mysqldump -u root -p megablog_mega > megablog_mega.sql mysqldump: Got error: 1105: File './megablog_mega/wp_43_options.MYD' not found (Errcode: 24) when using LOCK TABLES Thanks dev wrote on Wed, 11 October 2006 01:53 I see only one of 3 files requested. files: bc1, bc2, out. BTW, small mistake, run mysql-dump as: # strace -f -o out mysqldump -u root -p megablog_mega > megablog_blog.sql
creator: whatever
date: 2006-10-11T06:14:13-00:00

Re: Mysql dump error in VPS
type: item
description: 1. are you running mysql inside VE? 2. what kernel do you use? # uname -a 3. I need files content. # cat /proc/user_beancounters > bc1 doesn't generate output on the screen (if no error), but saves it to file 'bc1'. Are you trying to say, that file bc1 is empty? Same for files "bc2" and "out". Can you provide an access to the node? it will be quicker...
creator: dev
date: 2006-10-11T06:34:59-00:00

Re: Mysql dump error in VPS
type: item
description: # uname -a 2.6.9 #1 Wed Jun 21 12:01:20 MSD 2006 i686 i686 i386 GNU/Linux The output of bc1 and bc2 are attached. Shall I pm you the root access? dev wrote on Wed, 11 October 2006 02:34 1. are you running mysql inside VE? 2. what kernel do you use? # uname -a 2.6.9 #1 Wed Jun 21 12:01:20 MSD 2006 i686 i686 i386 GNU/Linux 3. I need files content. # cat /proc/user_beancounters > bc1 doesn't generate output on the screen (if no error), but saves it to file 'bc1'. Are you trying to say, that file bc1 is empty? Same for files "bc2" and "out". Can you provide an access to the node? it will be quicker...
creator: whatever
date: 2006-10-11T06:45:12-00:00

Re: Mysql dump error in VPS
type: item
description: yes, please pm
creator: dev
date: 2006-10-11T07:08:06-00:00

Re: Mysql dump error in VPS
type: item
description: 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.
creator: dev
date: 2006-10-11T08:11:56-00:00

Re: Mysql dump error in VPS
type: item
description: Seems you have modified the /etc/my.cnf to make it work I see open-files-limit=14096 Shall I try to take dump? Thanks
creator: whatever
date: 2006-10-11T08:22:59-00:00

Re: Mysql dump error in VPS
type: item
description: yes. it should work now.
creator: dev
date: 2006-10-11T08:35:50-00:00

Re: Mysql dump error in VPS
type: item
description: Thank you so much. I will try now and update you with the results
creator: whatever
date: 2006-10-11T08:41:48-00:00

Re: Mysql dump error in VPS
type: item
description: Thank you. It works perfectly fine dev wrote on Wed, 11 October 2006 04:35 yes. it should work now.
creator: whatever
date: 2006-10-11T12:18:36-00:00