Fam Wencong, Kenneth

My Diary

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