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.

Account Transfers not restoring all MySQL tables .....

Discussion in 'General Discussion' started by methos, Mar 23, 2008.

  1. methos

    methos Member

    Joined:
    Sep 25, 2007
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    We run hundreds of reseller accounts across a number of servers and, as such, are frequently using the 'transfer multiple accounts' feature to migrate accounts between servers.

    This week, during a major migration (decommissioning a server with hundreds of accounts) we have discovered that many of the sites are missing tables from their MySQL databases after the transfers.

    Does anyone know if this is a known bug in a recent update, since we have never had this problem before and we cannot possibly export and import all the missing tables manually .. we really need to find a solution to this issue as soon as possible ... any thoughts would be welcome ....

    The destination server is running WHM 11.15.0 cPanel 11.18.3-R21703, FEDORA 7 i686.

    Thanks,
     
  2. cbwass

    cbwass Well-Known Member

    Joined:
    Mar 29, 2002
    Messages:
    148
    Likes Received:
    0
    Trophy Points:
    16
  3. SupaDucta

    SupaDucta Active Member

    Joined:
    Oct 6, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Yep, mySQL dumps are broken with comments and wrong line breaks, so basically fixing this in editor and redumping in fixes.

    Horrible, STABLE should be well tested which obviously wasn't done properly.
     
    #3 SupaDucta, Mar 24, 2008
    Last edited: Mar 24, 2008
  4. VeZoZ

    VeZoZ Well-Known Member

    Joined:
    Dec 14, 2002
    Messages:
    248
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider

    Agreed and if a bad bug is introduced then patch it! It's been like this since most likely the 10th when cPanel released 21703 which was introduced to every version. So we're going on 2 weeks with it not fixed. If you want to count when the bug was reported then we're talking about almost 2 weeks...
     
  5. Arhineus

    Arhineus Well-Known Member

    Joined:
    Nov 1, 2005
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    6
    We're experiencing a similar issue, where we were doing all our account transfers via SSH (/scripts/pkgacct & /scripts/restorepkg). Not a single site with a database worked properly, and we're trying to get things corrected now.
     
  6. VeZoZ

    VeZoZ Well-Known Member

    Joined:
    Dec 14, 2002
    Messages:
    248
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    http://bugzilla.cpanel.net/show_bug.cgi?id=6412

    The bug report explains how to fix it. So easiest way is to just fix it yourself then run pkgacct again and the mysql databases should be fine.
     
  7. AlexV.

    AlexV. Well-Known Member

    Joined:
    Jun 15, 2006
    Messages:
    212
    Likes Received:
    1
    Trophy Points:
    16
    This issue has been addressed in all builds
    without publishing new builds. On systems set to update automatically,
    they will receive this fix during upcp.

    Otherwise you can simply run '/scripts/upcp --force' manually.
     
  8. Arhineus

    Arhineus Well-Known Member

    Joined:
    Nov 1, 2005
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    6
    Both servers involved are running WHM 11.15.0 cPanel 11.18.3-S21703 w/CENTOS Enterprise 4.6 i686 on standard - WHM X v3.1.0.

    I've tried copying the same accounts via the WHM transfer feature, and still no luck with this. I have an open ticket with support, but no progress with getting things working yet.
     
Loading...

Share This Page