Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

100's of accounts transfered with empty databases then phpadmin brakes FML

Discussion in 'General Discussion' started by WebHostPro, Jan 4, 2012.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,654
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Cpanel your killing me, not only didn't transfer hundreds of account incorrectly.

    You broke at the worst time and now because phpmyadmin doesn't work I can't even transfer the databases easily.

    Your killing me, seriously I might die from this.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 WebHostPro, Jan 4, 2012
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    Hello :)

    I highly suggest opening a support ticket for this issue if you continue to experience problems:

    Submit A Ticket

    This will allow us to investigate and determine the exact reason why the transfer failed.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jan 5, 2012
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    Hello,

    It's unfortunate you had issues with account transfers to a new machine. Without more details, though, it would be difficult to help you figure out what isn't working properly.

    Is MySQL running on both machines and is root user able to access?

    Code:
    ps aux | grep mysql
mysql
    If MySQL is running properly, review the transfer log in WHM > Transfers > Review Copied Accounts > View Log link for one of the accounts to see if any errors show there. If they do, please provide the error message here.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelTristan, Jan 5, 2012
  4. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,654
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    The server I'm transferring from gives this:

    [root@dwhs12 ~]# ps aux | grep mysql
    root 3244 0.0 0.0 6216 1228 ? S 2011 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/dwhsxx1.dwhs.net.pid
    mysql 3288 1.0 3.3 204648 103080 ? Sl 2011 1150:45 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/dwhsxx1.dwhs.net.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
    root 9469 0.0 0.0 3952 648 pts/0 S+ 15:41 0:00 grep mysql

    And the new server gives this:


    root 28115 0.0 0.0 4100 1116 ? S Jan04 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/dwhsxx2.dwhs.net.pid
    mysql 28188 0.5 1.0 118796 21784 ? Sl Jan04 7:29 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/dwhsxx2.dwhs.net.err --pid-file=/var/lib/mysql/dwhsxx2.dwhs.net.pid --socket=/var/lib/mysql/mysql.sock
    root 31368 0.0 0.0 4680 660 pts/0 S+ 15:43 0:00 grep mysql

    I'm going to try the transfer again, every mysql database did not transfer.

    The transfer log says it went fine:

    Restoring MySQL databases....
    ...........
    Done
    Restoring database charlesy_wrdp3......
    Done
    Restoring database charlesy_wrdp2......
    Done
    Done
    Done

    But the databases are all empty. Basically the tables did not transfer but the databases and users did.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 WebHostPro, Jan 5, 2012
  5. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,654
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    I also tried a single account transfer and the database is empty as well.

    I have a ticket in BTW but no response yet from yesterday.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 WebHostPro, Jan 5, 2012
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    Could you let us know the ticket number so we can check on the status?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Jan 6, 2012
  7. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,654
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    Sure, 2106718

    I didn't get the email so I didn't reply but I noticed they asked for something I need. Thanks for helping, I exporting and importing 100+ db's this sucks lol
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 WebHostPro, Jan 6, 2012
  8. Brian

    Brian Well-Known Member

    Joined:
    Dec 1, 2010
    Messages:
    117
    Likes Received:
    2
    Trophy Points:
    68
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Re: 100's of accounts transfered with empty databases then phpadmin brakes

    Just updating this thread in case any folks searching through threads in the future encounter this and wondered what the solution was to this issue. A bogus/bad custom configuration existed in /etc/my.cnf that was causing mysqldump to fail. Since mysqldump failed, no MySQL data was ever backed up.

    The solution was to remove the bogus/bad custom configuration out of /etc/my.cnf and re-transfer the accounts.

    Example:
    Code:
    # mysqldump user_db > user_db.sql
mysqldump: unknown variable 'quickmax_allowed_packet=16M'
    To protect against this issue, simply double-check that any customizations made to /etc/my.cnf are syntactically correct and comply with the MySQL version that you're using (flags/options CAN change from MySQL version to version).
     
    #8 Brian, Jan 7, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - 100's accounts transfered
  1. PaulPlantzos

    New Thread Problem with email accounts after migration

    PaulPlantzos, Oct 15, 2018 at 1:59 PM, in forum: Migrate to cPanel
    Replies:
    0
    Views:
    188
    PaulPlantzos
    Oct 15, 2018 at 1:59 PM
  2. Sujoy Dhar

    Suspend all cPanel accounts at once?

    Sujoy Dhar, Oct 13, 2018 at 3:39 PM, in forum: General Discussion
    Replies:
    5
    Views:
    71
    cPanelLauren
    Oct 16, 2018 at 3:01 PM
  3. Elizabeta

    Checking bandwidth for accounts in cPanel

    Elizabeta, Oct 9, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    67
    Elizabeta
    Oct 15, 2018 at 2:19 AM
  4. JesusSuarz

    Problem with DNS and Addon Domains after transferring accounts

    JesusSuarz, Oct 8, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    178
    cPanelLauren
    Oct 9, 2018
  5. Palo Pillien

    Place accounts on different drives?

    Palo Pillien, Oct 8, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    54
    Palo Pillien
    Oct 10, 2018 at 6:16 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice