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!

move server 2 server but not mysql ?

Discussion in 'General Discussion' started by Sopos, Jul 15, 2003.

  1. Sopos

    Sopos Well-Known Member

    Joined:
    Nov 16, 2001
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    306
    Good morning,
    I need to move a lot of account from one server (without root pwd) to my server.
    I have tried to move the account and it works. The only problem that I have is on the mysql dbase.
    Here it is the error when I try to copy the account :

    [.....]
    Restoring mysql dbs....Done
    Restoring mysql privs....ERROR 1136 at line 1: Column count doesn't match value count at row 1
    ERROR 1136 at line 2: Column count doesn't match value count at row 1
    ERROR 1136 at line 3: Column count doesn't match value count at row 1
    ERROR 1136 at line 4: Column count doesn't match value count at row 1
    ERROR 1136 at line 5: Column count doesn't match value count at row 1
    Done
    Reloading Mysql Privs....Done

    [.....]

    This error happen on every domain.
    If I go in mysql command line I see a dbase with a name different from the original but with the correct contenents.
    In the user cpanel interface I see a dbase with a different name and no user associated to it.

    Anyone has had the same problem ?

    Thank you

    cPanel.net Support Ticket Number:
     
Loading...

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.
    Dismiss Notice