Wondering how to manually dump a non-user MySQL database in cPanel? Our skilled Support Engineers are here with a solution.

Our Server Management Services offer help with all sorts of queries. Let’s find out how our Support Team tackles manually dumping a non-user MySQL database.

How to manually dump a non-user MySQL database in cPanel

If you are looking for a way to manually dump a MySQL database and then copy it to another server, you have come to the right place. Let’s see what our Support Engineers have to say.

1. First access the source server as root user via SSH.
2. Next, dump the database with the following command after replacing “db” with the name of the database that you want to dump.

   mysqldump db > db.sql

3. After that, use the following command to copy the database file to the destination server. Remember to replace 203.0.112.31 with the destination server’s IP address.

   scp db.sql root@204.0.112.31:/root

4. Then, as the root user, access the destination server through SSH.
5. Next, create a new database in MySQL with this command:

   mysql -e 'create database db'

6. After that, import the file into MySQL with this command:

   mysql db < db.sql

This is how you manually dump a MySQL database in cPanel.

[Need help with Server Management? We are at your service.]

Conclusion

To summarize, we learned how to manually dump a MySQL database and copy it to another server under the guidance of the Support Team at Bobcares.