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.

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:
    303
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Acequias :: Granada :: 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
     
    #3 speckados, Nov 15, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysqldump error
  1. SpiritualWorlds

    ERROR in "MysqlDump" Access denied?

    SpiritualWorlds, Mar 4, 2016, in forum: Database Discussions
    Replies:
    6
    Views:
    1,179
    cPanelMichael
    Mar 9, 2016
  2. Cody Brown

    Mysqldump issue

    Cody Brown, Mar 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    396
    cPanelMichael
    Mar 23, 2017
  3. Misiek

    Error with cpanel_dovecot_solr_maintenance cron

    Misiek, Jul 26, 2017 at 4:14 AM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    29
    cPanelMichael
    Jul 26, 2017 at 2:24 PM
  4. DavidPD

    Errors when changing PHP version in MultiPHP Manager

    DavidPD, Jul 25, 2017 at 8:51 PM, in forum: EasyApache
    Replies:
    2
    Views:
    24
    DavidPD
    Jul 26, 2017 at 6:01 PM
  5. Leslie de Groot

    ERR_SSL_PROTOCOL_ERROR after creating new account

    Leslie de Groot, Jul 25, 2017 at 8:15 PM, in forum: General Discussion
    Replies:
    2
    Views:
    37
    cPanelMichael
    Jul 26, 2017 at 12:19 PM

Share This Page