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!

Mysqldump error in VPS

Discussion in 'General Discussion' started by jolly, Oct 10, 2006.

  1. jolly

    jolly Member

    Joined:
    Dec 5, 2002
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    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
     
    #1 jolly, Oct 10, 2006
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    166
    Try something like this and throw it in a gz if desired.

    /usr/bin/mysqldump --opt -Q user | gzip > /home/destination/filename.gz
     
    #2 jayh38, Oct 10, 2006
  3. speckados

    speckados Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    325
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Pastrana :: Guadalajara :: España
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    This problem it's because database it's very large on tables, and --lock can't open files that it needs.

    try mysqldump without --lock-tables

    Code:
    mysqldump --lock-tables=false --add-drop-table --add-locks --create-options --disable-keys --extended-insert  --quick --set-charset [database] > [database].sql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 speckados, Nov 15, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysqldump error
  1. Netcrusher

    Backup with errors - roundcube mysqldump failed

    Netcrusher, Nov 19, 2018, in forum: Data Protection
    Replies:
    2
    Views:
    215
    Netcrusher
    Nov 26, 2018
  2. LaLi

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    LaLi, Jul 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    348
    cPanelLauren
    Jul 30, 2018
  3. Bashy

    mysqldump: Got error: 130: Incorrect file format

    Bashy, Feb 27, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    713
    cPanelMichael
    Feb 28, 2018
  4. Nirjonadda

    mysqldump: Got error: 1045: Access denied for user

    Nirjonadda, Aug 30, 2017, in forum: EasyApache
    Replies:
    13
    Views:
    5,784
    cPanelMichael
    Sep 11, 2017
  5. Bdzzld

    Mysqldump failure during automatic backups (max_allowed_packet)

    Bdzzld, Sep 18, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    158
    cPanelLauren
    Sep 18, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice