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.
- First access the source server as root user via SSH.
- 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
- After that, use the following command to copy the database file to the destination server. Remember to replace 126.96.36.199 with the destination server’s IP address.
scp db.sql [email protected]:/root
- Then, as the root user, access the destination server through SSH.
- Next, create a new database in MySQL with this command:
mysql -e 'create database db'
- 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.]
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.