mysqldump error

Discussion in 'Server Operation' started by sjau, Apr 20, 2006.

  1. sjau

    sjau Local Meanie Moderator


    I'm using this command for dumping my databases:

    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
  2. falko

    falko Super Moderator Howtoforge Staff

    Never seen this error before. Did you delete files or directories on the shell?
  3. sjau

    sjau Local Meanie Moderator

    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:

    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:


Share This Page