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!

database problem afther copy account from server to server

Discussion in 'General Discussion' started by wimp, May 27, 2004.

  1. wimp

    wimp Well-Known Member

    Joined:
    Jul 13, 2002
    Messages:
    301
    Likes Received:
    0
    Trophy Points:
    166
    hi all,
    afther moving accounts to a new server i note that most of databases are not working correctly.. They has all ben transfered however they dont work as the password are not accepted or customers cannot login to manage there application ( helpdesks, forums etc)
    Do i miss some steps when transfering databases with CPanel ?
    Is there any way to reset databases?


    Thanks a lot
     
    #1 wimp, May 27, 2004
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    782
    Likes Received:
    5
    Trophy Points:
    318
    Location:
    N.W. Iowa
    How did you move/copy the databases from one server to another? Are both the old and new servers running the same version of mysql ?? Did you setup the mysql database with all the privileges for each customers... ??

    Alot more then coping files :) this is where mysqldump is your friend :D

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 mickalo, May 27, 2004
  3. wimp

    wimp Well-Known Member

    Joined:
    Jul 13, 2002
    Messages:
    301
    Likes Received:
    0
    Trophy Points:
    166
    i move them with the account copier in WHM. Yes there are diff. vers. of mysql 3.x.x on the old server and 4.x.x on the new. However, i saw there are some libreries not yet installed on the new server... i will try install and see what happens..
     
    #3 wimp, May 28, 2004
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    782
    Likes Received:
    5
    Trophy Points:
    318
    Location:
    N.W. Iowa
    Ok, MySQL 4.0+ requires different privilege tables now and some other changes. If you go here Upgrading 3.23+ to 4.0.+ it'll explain it all very well.

    the account copier only copies the folders /home/<username> and not the actual database files, those are in a completely different location. Use mysqldump to transfer your databases, and following the directions for upgrading above and you should be back in business :)

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 mickalo, May 28, 2004
(You must log in or sign up to post here.)
Loading...
Similar Threads - database problem afther
  1. hamza bel

    Databases not found problem

    hamza bel, Jun 10, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    470
    cPanelMichael
    Jun 12, 2018
  2. Tjay322

    Problem importing zipped CSV into a database

    Tjay322, May 10, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    1,138
    cPanelMichael
    May 11, 2017
  3. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    669
    cPanelMichael
    May 4, 2017
  4. HostSane

    New Thread Mysql Database sync between 2 servers

    HostSane, Dec 10, 2018 at 7:23 AM, in forum: Database Discussion
    Replies:
    0
    Views:
    35
    HostSane
    Dec 10, 2018 at 7:23 AM
  5. Apurv Chaturvedi

    Database marked as crashed and should be repaired

    Apurv Chaturvedi, Nov 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    137
    cPanelLauren
    Nov 21, 2018

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