1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqldump: Error 2013: Lost connection to MySQL server during query

Discussion in 'General PHP and MySQL Discussions' started by ARSamo, Nov 15, 2013.

  1. ARSamo

    ARSamo Member

    Hi,
    When I wana copying xenforo_db to newxenforo_db for testing purpose using putty following ssh command:

    Code:
    mysqldump -uDB_user -p=DB_pass -hDB_host xenforo_db | mysql -uDB_user -pDB_pass -hDB_host newxenforodb
    Initially i got max_allowed_ packet error...

    after googling i changed the command as :

    Code:
    mysqldump --opt -max_allowd_packet=1G -uDB_user -p=DB_pass -hDB_host xenforo_db | mysql -uDB_user -pDB_pass -hDB_host newxenforodb
    and this time i got the error:

    The numbers are always different in each error log.

    I am confused how to change net_write_timeout and net_read_ timeout using ssh.

    i have godaddy shared hosting

    Can anyone help?
     
  2. ARSamo

    ARSamo Member

  3. MattW

    MattW Well-Known Member

    Rather than piping it straight into a new DB, why not just output the DB to a file, and then re-import separately?

    mysqldump --opt -max_allowd_packet=1G -uDB_user -p=DB_pass -hDB_host xenforo_db > db.sql

    mysql -uDB_user -pDB_pass -hDB_host newxenforodb < db.sql
     
    ARSamo likes this.
  4. ARSamo

    ARSamo Member

    Thanks @MattW for reply...
    in this case i received following error:
    Code:
    ERROR 1034 (HY000) at line 3209: 22 when fixing table
    My sourceDb has 151 tables but when i backup & restore through godaddy built-in db import export procedure.. every time only 94 tables were restored...

    I have also made ticket to godaddy twice but no email / responce received from supporting team since 82 hours..

    Any one help me .. because i wana testing the update procedure before upgrading live forum on xf 1.2.x
     
  5. ARSamo

    ARSamo Member

    now i am using godaddy corn job through bash command line Schedule backup but receiving error of :

    Any One help please..

    @Brogan @Jake Bunce
     
  6. MattW

    MattW Well-Known Member

    That is your host killing your backup script due to the amount of CPU time being taken.
     

Share This Page