The mysql backup procedure is standard. Same procedure in wpress or another CMS.

https://help.dreamhost.com/hc/en-us/articles/215039758 is the article I followed.

In all cases, the artifact is a *.sql file of megabytes. It takes a second to generate this file

You need to save (notepad) your db hostname, db name, login credentials. Not hard.

— ssh/mysqldump is crude. I like this method because it gave me access to the linux host, and builds my confidence.

— phpMyAdmin is convenient.

• artifacts downloads to browser
• the data transfer can take a minute for a 20MB file
• phpMyAdmin is fairly standard and stable, available in most web hosts.