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!

MySQL Dump Error 2013

Discussion in 'Database Discussion' started by deadend, Mar 11, 2010.

  1. deadend

    deadend Active Member

    Joined:
    Jan 18, 2007
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    156
    Hi Guys,

    I am trying to get a database to dump via command-line and for the life of me I cannot get it to dump without erroring out.

    My my.cnf
    I am not finding anything in the error log after each and I do not believe the sql server is crashing at anytime.

    Using the CPanel backup I get a DB of ~100MB and via commandline I get the same size before the error. So I am sure the issue is with my mysql server or configs.

    Any assistance appreciated.
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,309
    Likes Received:
    393
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might try running a repair on the DB via phpMyAdmin first just to check it. Can you post the command you're using to back it up?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. deadend

    deadend Active Member

    Joined:
    Jan 18, 2007
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    156
    I have tried about every command-line in the book :(

    I tried uncompressed, compressed, with and without the switches etc.

    I am at a loss, I have never run into an issue before, especially not via command prompt.

    Thanks!
     
  4. fmidaglia

    fmidaglia Registered

    Joined:
    Aug 27, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Same problem here, when cpbackup runs, no backup are generated.
    Any solution??

    *DATA*
    17:45:33 up 168 days, 1:49, 1 user, load average: 0.17, 0.16, 0.32
    ******

    ****/usr/local/cpanel/logs/error_log *****
    [2011-02-21 16:54:44 -0300] warn [pkgacct] pepe_db6: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_statpress` at row: 1049404
    at /scripts/pkgacct line 1398
    Script::Pkgacct::_check_error_file('pepe_db6', '/backup/cpbackup/daily/cruzroja/mysql/pepe_db6.sql.err') called at /scripts/pkgacct line 1367
    Script::Pkgacct::mysqldumpdb(HASH(0x8c4900c)) called at /scripts/pkgacct line 1052
    Script::Pkgacct::__ANON__() called at /scripts/pkgacct line 2010
    Script::Pkgacct::run_dot_event(CODE(0x8c490cc)) called at /scripts/pkgacct line 1055
    Script::Pkgacct::script('Script::Pkgacct', 'pepe', '/backup/cpbackup/daily', 'backup', 'nocompress') called at /scripts/pkgacct line 84
    *************

    ***/usr/local/cpanel/logs/cpbackup/1298316650.log***
    ...
    Storing ssl domain......Done
    Copying password.......Done
    Copying shell.......Done
    Creating Archive ....
    ERROR: tar of backup archive returned error 25
    Done
    pkgacctfile is: /backup/cpbackup/daily/pepe.tar
    md5sum is: aeb9fee079e798258c64037c73d702fd

    size is: 2147483647
    [cpbackup] The following backups were already up to date: weekly,monthly
    [cpbackup] Completed at Mon Feb 21 17:20:10 2011
    Notification => soporte@cruzroja.org.ar via EMAIL [level => 2]
    *************
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    What do you have in /etc/my.cnf file? If you have any timeouts or any settings that are restricting the size of packets, please comment those variables out and try the command again.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice