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.

Database didn't migrate

Discussion in 'Database Discussions' started by ub3rst4r, Apr 30, 2014.

  1. ub3rst4r

    ub3rst4r Registered

    Joined:
    Apr 30, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I moved cPanel accounts from one server to another. One of the accounts MySQL didn't migrate properly though. I wasn't thinking and I didn't create a backup of everything on the server nor did I check all of the logs created from the migration. It seems that the server that I migrated from has now been wiped and I won't be able to get anything from it. I'm hoping there's some sort of backup that I can get from the new server so does anyone know where it might be? I have included the log showing the MySQL errors. I also wish that cPanel would put in a feature so if the SQL didn't get imported properly than a backup of it would be created.

    Code:
    Restoring MySQL databases....
    Restoring database xxxxx_wpxxxx......
    ERROR 2006 (HY000) at line 556: MySQL server has gone away 
    ERROR 2006 (HY000) at line 557: MySQL server has gone away 
    ERROR 2006 (HY000) at line 558: MySQL server has gone away 
    ERROR 2006 (HY000) at line 559: MySQL server has gone away 
    ERROR 2006 (HY000) at line 565: MySQL server has gone away 
    ERROR 2006 (HY000) at line 566: MySQL server has gone away 
    ERROR 2006 (HY000) at line 567: MySQL server has gone away 
    ERROR 2006 (HY000) at line 568: MySQL server has gone away 
    ERROR 2006 (HY000) at line 577: MySQL server has gone away 
    ERROR 2006 (HY000) at line 583: MySQL server has gone away 
    ERROR 2006 (HY000) at line 584: MySQL server has gone away 
    ERROR 2006 (HY000) at line 585: MySQL server has gone away 
    ERROR 2006 (HY000) at line 586: MySQL server has gone away 
    ERROR 2006 (HY000) at line 587: MySQL server has gone away 
    ERROR 2006 (HY000) at line 593: MySQL server has gone away 
    ERROR 2006 (HY000) at line 594: MySQL server has gone away 
    ERROR 2006 (HY000) at line 595: MySQL server has gone away 
    ERROR 2006 (HY000) at line 596: MySQL server has gone away 
    ERROR 2006 (HY000) at line 626: MySQL server has gone away 
    ERROR 2006 (HY000) at line 632: MySQL server has gone away 
    ERROR 2006 (HY000) at line 633: MySQL server has gone away 
    ERROR 2006 (HY000) at line 634: MySQL server has gone away 
    ERROR 2006 (HY000) at line 635: MySQL server has gone away 
    ERROR 2006 (HY000) at line 636: MySQL server has gone away 
    ERROR 2006 (HY000) at line 637: MySQL server has gone away 
    ERROR 2006 (HY000) at line 643: MySQL server has gone away 
    ERROR 2006 (HY000) at line 644: MySQL server has gone away 
    ERROR 2006 (HY000) at line 645: MySQL server has gone away 
    ERROR 2006 (HY000) at line 646: MySQL server has gone away 
    ERROR 2006 (HY000) at line 663: MySQL server has gone away 
    ERROR 2006 (HY000) at line 669: MySQL server has gone away 
    ERROR 2006 (HY000) at line 670: MySQL server has gone away 
    ERROR 2006 (HY000) at line 671: MySQL server has gone away 
    ERROR 2006 (HY000) at line 672: MySQL server has gone away 
    ERROR 2006 (HY000) at line 678: MySQL server has gone away 
    ERROR 2006 (HY000) at line 679: MySQL server has gone away 
    ERROR 2006 (HY000) at line 680: MySQL server has gone away 
    ERROR 2006 (HY000) at line 681: MySQL server has gone away 
    ERROR 2006 (HY000) at line 690: MySQL server has gone away 
    ERROR 2006 (HY000) at line 696: MySQL server has gone away 
    ERROR 2006 (HY000) at line 697: MySQL server has gone away 
    ERROR 2006 (HY000) at line 698: MySQL server has gone away 
    ERROR 2006 (HY000) at line 699: MySQL server has gone away 
    ERROR 2006 (HY000) at line 705: MySQL server has gone away 
    ERROR 2006 (HY000) at line 706: MySQL server has gone away 
    ERROR 2006 (HY000) at line 707: MySQL server has gone away 
    ERROR 2006 (HY000) at line 708: MySQL server has gone away 
    ERROR 2006 (HY000) at line 718: MySQL server has gone away 
    ERROR 2006 (HY000) at line 724: MySQL server has gone away 
    ERROR 2006 (HY000) at line 725: MySQL server has gone away 
    ERROR 2006 (HY000) at line 726: MySQL server has gone away 
    ERROR 2006 (HY000) at line 727: MySQL server has gone away 
    ERROR 2006 (HY000) at line 728: MySQL server has gone away
    ERROR 2006 (HY000) at line 734: MySQL server has gone away
    ERROR 2006 (HY000) at line 735: MySQL server has gone away
    ERROR 2006 (HY000) at line 736: MySQL server has gone away
    ERROR 2006 (HY000) at line 737: MySQL server has gone away
    ERROR 2006 (HY000) at line 762: MySQL server has gone away
    ERROR 2006 (HY000) at line 768: MySQL server has gone away
    ERROR 2006 (HY000) at line 769: MySQL server has gone away
    ERROR 2006 (HY000) at line 770: MySQL server has gone away
    ERROR 2006 (HY000) at line 771: MySQL server has gone away
    ERROR 2006 (HY000) at line 777: MySQL server has gone away
    ERROR 2006 (HY000) at line 778: MySQL server has gone away
    ERROR 2006 (HY000) at line 779: MySQL server has gone away
    ERROR 2006 (HY000) at line 780: MySQL server has gone away
    ERROR 2006 (HY000) at line 791: MySQL server has gone away
    ERROR 2006 (HY000) at line 797: MySQL server has gone away
    ERROR 2006 (HY000) at line 798: MySQL server has gone away
    ERROR 2006 (HY000) at line 799: MySQL server has gone away
    ERROR 2006 (HY000) at line 800: MySQL server has gone away
    ERROR 2006 (HY000) at line 806: MySQL server has gone away
    ERROR 2006 (HY000) at line 807: MySQL server has gone away
    ERROR 2006 (HY000) at line 808: MySQL server has gone away
    ERROR 2006 (HY000) at line 809: MySQL server has gone away
    ERROR 2006 (HY000) at line 819: MySQL server has gone away
    ERROR 2006 (HY000) at line 825: MySQL server has gone away
    ERROR 2006 (HY000) at line 826: MySQL server has gone away
    ERROR 2006 (HY000) at line 827: MySQL server has gone away
    ERROR 2006 (HY000) at line 828: MySQL server has gone away
    ERROR 2006 (HY000) at line 829: MySQL server has gone away
    ERROR 2006 (HY000) at line 835: MySQL server has gone away
    ERROR 2006 (HY000) at line 836: MySQL server has gone away
    ERROR 2006 (HY000) at line 837: MySQL server has gone away
    ERROR 2006 (HY000) at line 838: MySQL server has gone away
    ERROR 2006 (HY000) at line 847: MySQL server has gone away
    ERROR 2006 (HY000) at line 853: MySQL server has gone away
    ERROR 2006 (HY000) at line 854: MySQL server has gone away
    ERROR 2006 (HY000) at line 855: MySQL server has gone away
    ERROR 2006 (HY000) at line 856: MySQL server has gone away
    ERROR 2006 (HY000) at line 857: MySQL server has gone away
    ERROR 2006 (HY000) at line 863: MySQL server has gone away
    ERROR 2006 (HY000) at line 864: MySQL server has gone away
    ERROR 2006 (HY000) at line 865: MySQL server has gone away
    ERROR 2006 (HY000) at line 866: MySQL server has gone away
    ERROR 2006 (HY000) at line 876: MySQL server has gone away
    ERROR 2006 (HY000) at line 882: MySQL server has gone away
    ERROR 2006 (HY000) at line 883: MySQL server has gone away
    ERROR 2006 (HY000) at line 884: MySQL server has gone away
    ERROR 2006 (HY000) at line 885: MySQL server has gone away
    ERROR 2006 (HY000) at line 891: MySQL server has gone away
    ERROR 2006 (HY000) at line 892: MySQL server has gone away
    ERROR 2006 (HY000) at line 893: MySQL server has gone away
    ERROR 2006 (HY000) at line 894: MySQL server has gone away
    ERROR 2006 (HY000) at line 901: MySQL server has gone away
    ERROR 2006 (HY000) at line 907: MySQL server has gone away
    ERROR 2006 (HY000) at line 908: MySQL server has gone away
    ERROR 2006 (HY000) at line 909: MySQL server has gone away
    ERROR 2006 (HY000) at line 910: MySQL server has gone away
    ERROR 2006 (HY000) at line 911: MySQL server has gone away
    ERROR 2006 (HY000) at line 917: MySQL server has gone away
    ERROR 2006 (HY000) at line 918: MySQL server has gone away
    ERROR 2006 (HY000) at line 919: MySQL server has gone away
    ERROR 2006 (HY000) at line 920: MySQL server has gone away
    ERROR 2006 (HY000) at line 931: MySQL server has gone away
    ERROR 2006 (HY000) at line 937: MySQL server has gone away
    ERROR 2006 (HY000) at line 938: MySQL server has gone away
    ERROR 2006 (HY000) at line 939: MySQL server has gone away
    ERROR 2006 (HY000) at line 940: MySQL server has gone away
    ERROR 2006 (HY000) at line 941: MySQL server has gone away
    ERROR 2006 (HY000) at line 947: MySQL server has gone away
    ERROR 2006 (HY000) at line 948: MySQL server has gone away
    ERROR 2006 (HY000) at line 949: MySQL server has gone away
    ERROR 2006 (HY000) at line 950: MySQL server has gone away
    ERROR 2006 (HY000) at line 959: MySQL server has gone away
    ERROR 2006 (HY000) at line 965: MySQL server has gone away
    ERROR 2006 (HY000) at line 966: MySQL server has gone away
    ERROR 2006 (HY000) at line 967: MySQL server has gone away
    ERROR 2006 (HY000) at line 968: MySQL server has gone away
    ERROR 2006 (HY000) at line 969: MySQL server has gone away
    ERROR 2006 (HY000) at line 975: MySQL server has gone away
    ERROR 2006 (HY000) at line 976: MySQL server has gone away
    ERROR 2006 (HY000) at line 977: MySQL server has gone away
    ERROR 2006 (HY000) at line 978: MySQL server has gone away
    ERROR 2006 (HY000) at line 987: MySQL server has gone away
    ERROR 2006 (HY000) at line 993: MySQL server has gone away
    ERROR 2006 (HY000) at line 994: MySQL server has gone away
    ERROR 2006 (HY000) at line 995: MySQL server has gone away
    ERROR 2006 (HY000) at line 996: MySQL server has gone away
    ERROR 2006 (HY000) at line 997: MySQL server has gone away
    ERROR 2006 (HY000) at line 1003: MySQL server has gone away
    ERROR 2006 (HY000) at line 1004: MySQL server has gone away
    ERROR 2006 (HY000) at line 1005: MySQL server has gone away
    ERROR 2006 (HY000) at line 1006: MySQL server has gone away
    ERROR 2006 (HY000) at line 1021: MySQL server has gone away
    ERROR 2006 (HY000) at line 1027: MySQL server has gone away
    ERROR 2006 (HY000) at line 1028: MySQL server has gone away
    ERROR 2006 (HY000) at line 1029: MySQL server has gone away
    ERROR 2006 (HY000) at line 1030: MySQL server has gone away
    ERROR 2006 (HY000) at line 1031: MySQL server has gone away
    ERROR 2006 (HY000) at line 1036: MySQL server has gone away
    ERROR 2006 (HY000) at line 1038: MySQL server has gone away
    ERROR 2006 (HY000) at line 1039: MySQL server has gone away
    ERROR 2006 (HY000) at line 1040: MySQL server has gone away
    ERROR 2006 (HY000) at line 1041: MySQL server has gone away
    ERROR 2006 (HY000) at line 1042: MySQL server has gone away
    ERROR 2006 (HY000) at line 1043: MySQL server has gone away
    ERROR 2006 (HY000) at line 1044: MySQL server has gone away 
    Done
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The output you provided does not necessarily indicate the MySQL data is missing from the archive. What error messages do you see in the MySQL error log (/var/lib/mysql/$hostname.err) when restoring the account?

    Thank you.
     
  3. ub3rst4r

    ub3rst4r Registered

    Joined:
    Apr 30, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    There's nothing in any .err files. There's no backup to restore the account either. Any other ideas?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Are those logs from when the account was initially transferred? To confirm, there are no archives or access to the source server? If not, there is not much we can do to investigate the issue, unfortunately.

    Thank you.
     
  5. ub3rst4r

    ub3rst4r Registered

    Joined:
    Apr 30, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I can get access to the server. However, the provider wants $45 USD for another month, even though I just need it for like 10 minutes.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You would need access to the source server in order to determine why the account was not packaged/transferred successfully or to attempt to package the account and check the database.

    Thank you.
     
Loading...

Share This Page