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.

problem with database username after moving sites

Discussion in 'General Discussion' started by iLinux85, Dec 4, 2013.

  1. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    hello

    after moving sites from old server to new server i cannot find the usernames , how can i recreate or show the database username already exist and assigned to database name

    and where the database username information or path would be found in the server

    for example database names and data found in /var/lib/mysql

    but database username where is the path ?

    and where is the database username path in the backup too ?

    Regards,
     
  2. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    i found that database usernames saved in /var/cpanel/database and /var/cpanel/datastore

    where i can find the information about database username in the backup and restore it manually ?
     
  3. quietFinn

    quietFinn Well-Known Member

    Joined:
    Feb 4, 2006
    Messages:
    998
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Finland
    cPanel Access Level:
    Root Administrator
    The database(s) and username(s) can be seen in accounts's cPanel.
     
  4. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    the problem is i moved mysql only from /var/lib/mysql to another server but the database's users not moved , i want to know is there anyway to recreate it again automatic from backup files i have would be great
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The method you used to manually transfer the databases is not recommended or supported. The database usernames and databases should have been included in the account backup archives. Do you have the backup archives of the accounts from the source server? Is the source server still active?

    Thank you.
     
Loading...

Share This Page