Bobcares

wesupport

CLIENT AREACall Us 1-800-383-5193
Bobcares

wesupport

Call Us 1-800-383-5193
Bobcares

wesupport

Call Us 1-800-383-5193

Need help?

Our experts have had an average response time of 11.7 minutes in August 2021 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

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 [email protected]:/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 *

Categories

Tags