mysqldump error

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

  1. sjau

    sjau Local Meanie Moderator

    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
     
    sjau, Apr 20, 2006
    #1
  2. falko

    falko Super Moderator Howtoforge Staff

    Never seen this error before. Did you delete files or directories on the shell?
     
    falko, Apr 21, 2006
    #2
  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:

     
    sjau, Apr 21, 2006
    #3

Share This Page