problem with database username after moving sites

iLinux85

• December 04, 2013 15:28

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,

• 

  iLinux85

  • December 04, 2013 20:55

  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 ?

  0
• 

  quietFinn

  • December 04, 2013 22:19

  [quote="iLinux85, post: 1521732">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
  The database(s) and username(s) can be seen in accounts's cPanel.

  0
• 

  iLinux85

  • December 04, 2013 22:32

  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

  0
• 

  cPanelMichael

  • December 05, 2013 17:23

  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.

  0

Please sign in to leave a comment.