InMotion Hosting Support Center
In this tutorial we will show you how to export a database from SSH. This is useful for many things such as when you are moving your site, since it exports the entire database, or before you attempt to upgrade a website, since it is essentially a backup of the database.
Generate a Database Backup:
  1. Connect to your server via SSH.
  2. In the command line enter the following code:

    mysqldump -u dbusername -p databasename > nameofdbbackup.sql

    Be sure to replace:
    dbusername = with the database username for the database you want to export.
    databasename = with the name of the database you want to export.
    nameofdbbackup = enter a name for the exported database.

  3. Hit the Enter key and it will ask you for your password. Type your password and hit the Enter key again, it will begin exporting, this may take some time to complete, depending how large your database is. Your SSH client will take you to a new line when this process completes.

    The database will now be available for download in your home directory.
Congratulations, now you know how to Export / Backup your database from SSH!
Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

n/a Points
2018-09-08 12:41 pm

I made a backup of a database 83 MB in size but the backup is only 36 MB. Why is this happening?

2,863 Points
2018-09-10 11:35 am
It's possible the backup is a compressed file, so it may not match up exactly. How big is the database when you import the backup?

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

2 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!