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!

Mysql restore error !!! Please assist

Discussion in 'Database Discussion' started by furquan, Jul 6, 2011.

  1. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    471
    Likes Received:
    4
    Trophy Points:
    168
    Hi,

    I was trying to restore the DB of a server after migration and these are the steps i followed :-

    But after i run the gunzip command after a few mins i get this error :-

    ERROR 1426 (42000) at line 50966: Too big precision 100 specified for column 'BussAchv'. Maximum is 65.

    Can any one please assist ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    471
    Likes Received:
    4
    Trophy Points:
    168
    Can any body help ???
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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
    Do both machines have the same MySQL version being used? This error could be due to using different MySQL versions.

    It's likely that the BussAchv column in the database that contains that has a decimal with 100 listed when 65 is the largest allowable decimal.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    471
    Likes Received:
    4
    Trophy Points:
    168
    Yes Tristan ...you are correct,,

    The versions of mysql on both the servers are different, i have downgraded the new server and it looks ok now.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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