#1  
Old 20th April 2006, 22:39
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,146
Thanks: 4
Thanked 55 Times in 51 Posts
Default mysqldump error

Hiya

I'm using this command for dumping my databases:

Code:
mysqldump -uroot -p********** -Q -c --add-drop-table --add-locks --quick --lock-tables --all-databases > /mysql_backup/backup.sql

It worked in the afternoon but not anymore tonight.

I receive this error message:

mysqldump: Got error: 1105: File './usr_web4_12/1140101384616.MYD' not found (Errcode: 24) when using LOCK TABLES
Reply With Quote
Sponsored Links
  #2  
Old 21st April 2006, 11:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Never seen this error before. Did you delete files or directories on the shell?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 21st April 2006, 11:54
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,146
Thanks: 4
Thanked 55 Times in 51 Posts
 
Default

I found out that the error is wrong... there's some bug. In reality it means mysql wanted to open too many files and I needed to change my my.cnf to:

Quote:
[mysqld_safe]
open-files-limit=8192
Furthermore I did also change my routine on how I create the dumps. I don't make a big .sql file anymore containing all data but split it up and create for each db an own .sql file:

Quote:
#Dump new files
USER=root
PASSWORD=***
HOST=localhost

for i in $(echo 'SHOW DATABASES;' | mysql -u$USER -p$PASSWORD -h$HOST|grep -v '$
mysqldump \
-u$USER -p$PASSWORD -h$HOST \
-Q -c -C --add-drop-table --add-locks --quick --lock-tables \
$i > /mysql_backup/$i.sql;
done;
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suse 10 perfect setup error .. keybd_user Installation/Configuration 6 9th April 2006 17:06
Fresh Install on Debian cksrealm Installation/Configuration 12 22nd February 2006 16:14
Installation Fails... :( cyberstorm Installation/Configuration 1 15th January 2006 18:07
Could not make OpenSSL yontengyatso Installation/Configuration 3 3rd November 2005 10:50
Install stop at uuwish, UUDeview SeaWolf Installation/Configuration 6 4th October 2005 23:53


All times are GMT +2. The time now is 20:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.