Copy a database from one account to another account by ssh

if you are looking to use same database for 2 different accounts on the same servers , backup the database first , then from cpanel create a new database for the another website from cpanel and restore the backup to that newely created database.

 

Support you want to copy database from one user to another shell, so the question is what shell level access do you have, root access or a user access?

If you have root access, perform the below steps:

1. Login to the server.

2. Create dump of the database using mysqldump command.
# mysqldump -u<username> -p user1DB > user1DB.sql

3. Create a new database under user2.

4. restore the dump you created in step 2 on this user using below command;
# mysql -u<username> -p user2DB < user1DB.sql