How To Backup Your WordPress Database
Published: Saturday, January 25, 2020
It’s good to do a backup of your WordPress database regularly. Or you could be migrating hosts and you want to figure out how to save your database first. Then this article is for you.
Dumping Data Via MySQL Workbench
If you are using MySQL Workbench, after logging in, click Data Export from your Navigator. Select the databases and enter the required options. Click export.
This option works if your MySQL Workbench version works with your MySQL Server. If not, you can use the mysqldump command. Continue reading below.
Dumping Data in SQL Format with mysqldump
Open your command prompt as Administrator. Navigate to mysqldump.exe.
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
Run the following command.
mysqldump -u root -p --databases db1 > dump.sql