Why would you want to manually backup a WordPress database?If for any reason you are unable to login to the WordPress admin area to use a plugin to backup your database then being able to manually backup a WordPress database will come in handy.
Manually backup WordPress using PHPMyAdminFirstly you will need to login to your hosting Control Panel and find the icons, which will normally be under the database section, which will give you access to PHPMyAdmin section. Once you are in the PHPMyAdmin section, you will want to select the export tab. Once the Export tab opens you will see a message at the top “Exporting tables from ‘database name’ database. The default export method is “Quick – display only minimal options and the default format is SQL. You simply need to click on the Go button and the finder window will open to allow you to save the database to your local drive.
Manually backup WordPress using WP-CLIIf you have access to WP-CLI through your hosting company, then there is an even simpler way to manually backup a WordPress database. Connect to your website using a terminal window and type in the following command wp db export You will now have a backup file in the root of your website with a file extension of .SQL .
ConclusionAs we mentioned manually backing up a WordPress database would be done if you cannot access your WordPress admin area. However, it is a better idea to use a plugin like Backup Buddy to schedule backups of your database and website. These backups could be stored on cloud platforms like Amazon S3, Dropbox, Google Drive or Stash.
YOU MAY ALSO ENJOY THESE ARTICLES
Getting a website up and running for your business can be an expensive exercise but in this tutorial, we are going […]