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.

MySQL Dump Error 2013

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

  1. deadend

    deadend Active Member

    Joined:
    Jan 18, 2007
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    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:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    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?
     
  3. deadend

    deadend Active Member

    Joined:
    Jan 18, 2007
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    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:
    1
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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.
     
Loading...

Share This Page