ccihosting.com
Have questions? Call us.
Panama: (+507) 264.0852

Exporting a MySQL via CLI (Command Line Interface)

CCIHosting.com knowledgebase

Knowledgebase

How to export a MySQL database using CLI (command line interface)

Using SSH, execute the following command:

mysqldump -p -u username database_name > dbname.sql

You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name. The file dbname.sql now holds a backup of your database and is ready for download to your computer.

To export a single table from your database you would use the following command:

mysqldump -p --user=username database_name tableName > tableName.sql

Again you would need to replace the username, database and tableName with the correct information. Once done the table specified would then be saved to your account as tableName.sql

Need a Web Hosting account?

Web Hosting

$ 6/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

VPS

$ 15/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

Cloud Servers

$ 35/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

Dedicated Servers

$ 90/month
Starting at

View Plans

  • 48 Hours or Less
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted
paypal
visa
mastercard
bitcoin

Need assistance choosing your right server? We are here to help

Call our sales team at +(507) 264.0852 or talk with us on Live Chat