The WordPress docs have some great information on how to do a WordPress database backup. But, the screenshots and instructions, at least for doing a WordPress database backup with phpMyAdmin, are slightly outdated. Below, I will include some instructions and screenshots on how to do a WordPress database backup.
At this point you should have a workable WordPress Database backup. Doing a WordPress database backup is not a hard task (at least once you’ve done it once or twice), and it’s relatively quick. But, if you run a website of any importance, you may look into getting a good WordPress backup plugin or getting managed WordPress hosting.
Using a plugin or a managed WordPress hosting provider can eliminate the need to do a WordPress database backup on your own. My personal recommendation is to look into a good managed WordPress hosting provider, such as WP Engine. WP Engine does daily automatic WordPress database backups, and has an easy restore button!
If you’d like some help with the maintenance of your WordPress website, then check out the WP Engine review to find out how WP Engine can help you with more than just doing a WordPress database backup.