Join Morten Rand-Hendriksen for an in-depth discussion in this video Backing up your WordPress site, part of WordPress Developer Tips: Managing Users in the Database.
In this WordPress developer tip, we'll look at how you can manage the user accounts in a WordPress site directly from the database. And anytime you work directly with the database, it is imperative that you make a full backup of the database, and also, ideally, your whole WordPress site before continuing. If you've never done a backup before, or you need to brush-up on how this is done, we have a course for exactly that purpose right in the lynda.com library. It's called WordPress Plugins: Backing Up Your Site.
And it walks you through the process of running full site backups using a multitude of different plugins. This course also shows how to restore a site from a backup if something goes wrong. So when you're working with a database, if something happens and you break something, you can always restore the site back to where it was before you started. If this is the first time you're working with the WordPress database, I strongly urge you to experiment using a locally installed version of WordPress, just like I'm doing here in this course.
If you're on a Mac, you can use MAMP. Or if you're on a Windows computer, you can use WAMP or any of the number of other options you have for installing WordPress locally. In the lynda.com library, we have a series of courses called Installing and Running WordPress that cover different methods for installing WordPress, both in local environments and on different types of servers. And to follow this course, I urge you to use one of the local environment options. So, once you have a full backup of your database and your site, or you have a local version of WordPress to work with, we're ready to get going with managing users in the database.