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.

pkgacct2 and problem with InnoDB tables

Discussion in 'General Discussion' started by Sindre, Apr 17, 2009.

  1. Sindre

    Sindre Well-Known Member

    Joined:
    Aug 25, 2008
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    I was transferring a cPanel account from one server to another today using the pkgacct2 script. Everything went well, but when I checked the database of the user in phpMyAdmin after restoring the account on the new server, all the InnoDB tables were missing. The MyISAM tables shows up correctly.

    Is this a bug in the account copy script, or is it a problem on my end?

    I would appreciate your feedback on this.

    PS: Both servers are running cPanel 11.24.4-R35075

    Thanks,
    Sindre
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I recommend using /scripts/pkgacct rather than /scripts/pkgacct2.

    Any particular reason you are using this manual method rather than using the WHM interface's Copy Account from Another Server or Copy Multiple Accounts from Another Server features? In 11.24, we have substantially improved the reliability and performance of account transfers.
     
  3. Sindre

    Sindre Well-Known Member

    Joined:
    Aug 25, 2008
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for the reply. I prefer to do things via the Shell as I won't have to bother with HTTP timeouts, etc. I just feel more confident creating the backup on server 1, then transferring the backup to server 2 using WGET or SCP.

    What is the difference between pkgacct and pkgacct2 ? I believe I have read somewhere that pkgacct is old and should not be used, however I might be mistaken.
     
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    We currently use /scripts/pkgacct for full account backups and transfers, hence my recommendation to use that. Looking at the copyright notice for pkgacct2, that looks very much outdated.

    We've fixed many of the issues with HTTP timeouts, but I see no problems with doing things the command line way in this scenario.

    There's some further details in doing transfers via the command line in our Backups and Transfers presentation from the 2007 cPanel Conference. You can view the slides from this presentation at:

    http://twiki.cpanel.net/twiki/pub/A...es/TrainingSlides07/Backups_and_Transfers.pdf
     
  5. Sindre

    Sindre Well-Known Member

    Joined:
    Aug 25, 2008
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Ok, thanks. I will use the pgkacct script next time. Anyway, back to the initial topic: can you confirm whether pkgacct (and following restore) will work with InnoDB tables/databases as well? It might be that this bug only applies to pkgacct2, though.
     
  6. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    It should be transferring InnoDB tables/databases. If you still experience this with /scripts/pkgacct from a server running cPanel/WHM 11.24 or later, then please let our technical analysts take a look at things for you.
     
Loading...

Share This Page