mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Hello :

How can copy mysql user from any server to other server ?
Mysqluser + database name
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,226
463
Hello :)

You can simply create the MySQL user on the destination server. MySQL databases are backed up the "Backup" option in cPanel or via a command such as:

Code:
mysqldump database_name > /path/to/database.sql
Then, after transferring the SQL file to the destination server, you can restore it via cPanel or with a command such as:

Code:
mysql database_name < /path/to/database.sql
You can map a database to an account via:

"WHM Home » SQL Services » Database Map Tool"

Thank you.