Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backup error on Database

Discussion in 'Data Protection' started by leonep, Oct 4, 2017.

Tags:
  1. leonep

    leonep Well-Known Member

    Joined:
    Nov 18, 2014
    Messages:
    67
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Pescara
    cPanel Access Level:
    Root Administrator
    In daily backup process i have this error . need help to fix please, thanks

    confpe_db[2017-10-04 02:02:36 +0200] confpe_db: mysqldump: Got error: 29: File './confpe_db/ifq_wfHits.MYD' not found (Errcode: 2) when using LOCK TABLES

    slccgila_bruzzo[2017-10-04 02:54:58 +0200] slccgila_bruzzo: mysqldump: Got error: 29: File './slccgila_bruzzo/wp_visitor_maps_wo.MYD' not found (Errcode: 2) when using LOCK TABLES
     
  2. HostingH

    HostingH Well-Known Member

    Joined:
    Jan 13, 2008
    Messages:
    98
    Likes Received:
    10
    Trophy Points:
    58
    cPanel Access Level:
    Root Administrator
    Hello,

    Please check open_files_limit and even though you are getting the errors but database backup will be fine.
    You can verify it. It seems that your database is big in size.

    If you want to run mysqldump use --skip-lock-tables option.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page