Bobcares

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

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

by | Oct 3, 2021

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.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.