problem with database username after moving sites

iLinux85

Well-Known Member
Mar 28, 2010
52
2
58
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

Well-Known Member
Mar 28, 2010
52
2
58
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 ?
 

quietFinn

Well-Known Member
Feb 4, 2006
1,222
87
178
Finland
cPanel Access Level
Root Administrator
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.
 

iLinux85

Well-Known Member
Mar 28, 2010
52
2
58
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.