Move a database from one account to another

[Abbas]

We've shifted our forums from one domain to another and thus I need to move the forums database from account1 to account2. What would be the easiest/fastest way to accomplish this?

Thanks

[JawadArshad]

We've shifted our forums from one domain to another and thus I need to move the forums database from account1 to account2. What would be the easiest/fastest way to accomplish this?

Thanks

- You can download your databases via cPanel >> Backups and restore them on the destination.

- You can create dumps of databases on the source server, transfer them over to the destination server and restore them. Here are the steps.

Login via SSH

1- go to /var/lib/mysql
2- mysqldump dbname > dbname.sql
This will create the database dump
3- scp dbname.sql root@hostname:/var/lib/mysql
4- Create empty database on destination using command.
mysqladmin create dbname
5- mysql dbname < dbname.sql
to restore the database dump

Make sure the version of MySQL are same on both sides and you know your way around Linux. If you do not have root access, simply download the database dumps from cPanel >> Backups, upload them on the destination and ask your host to restore them.