How to export WordPress database with SSH

Posted on: August 3rd, 2022
By: Tadeo Martinez

Connect through SSH, if you don’t know how, head over to this article How to connect to SSH with terminal to learn how.

Once you’re connected, navigate to the public_html folder and run the following command:

wp db export

You can also run the following command:

mysqldump -u dbuser -p dbname > dbfile.sql

* With the second command, you will be prompted for the database password.

It will export the file in the same public_html folder, which you can then download through FTP.

You can also see more detailed instructions in this article from Cloudways, How to Import and Export MySQL Database Using WordPress CLI.

Have any questions or comments? Write them below!

Leave a Reply

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