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 exportYou 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!