• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WPArena

WPArena

WPArena is a premium online resource site of WordPress and is focused on providing excellent WordPress Tutorials, Guides, Tips, and Collections.

  • News
    • Opinion
  • Tutorials
  • Reviews
    • Themes
    • Plugins
  • Comparisons
  • Collections
    • Education Themes
    • Genesis Child Themes
    • Best Responsive Themes
    • Medical WordPress Themes
    • Finance & Business Themes
    • Crowdfunding Themes
  • Resources
    • Inspiration
  • Services
WPArena » Tutorials
Tutorials

How To Backup WordPress Database Manually

Avatar of Editorial Staff Editorial Staff January 16, 2009

FacebookTweetPinLinkedInEmailPrint

Backing up your WordPress database is something most of us fail to do on a regular basis. I have yet to need a database backup to restore a catastrophic loss but have used them to move a WordPress blog to a new server and I always backup the database before an upgrade. There are two methods to backup your database, one is manually in the hosting account control panel the other is with a plugin. I like the manual method and will cover it in this WordPress guide.

Manual Backup of WordPress Database

If you have multiple databases you first need to know the correct database to backup. You might have different scripts or multiple WordPress blogs installed on your site and knowing which is which can be very useful information. So first get into the file manager on your hosting account and browse to the directory where the WordPress blog is installed. Look for and open the wp-config.php file.

Open wpconfig.php file

Once you open the wp-config.php file you will see the name of the database for your WordPress blog. All you need to do is look at this, make sure you don’t edit it and then close the file without making any changes.

Backup WordPress Database Details

Now armed with the proper information you can export your database. Back at the main page of your control panel look for the phpMyAdmin menu. If that isn’t an option then look for a MySQL Database menu icon or link. Host4Profit users will need to access phpMyAdmin by clicking the database after clicking the MySQL Database link icon.

When you are in phpMyAdmin click the drop down box on the far left under database and choose the correct database. This will open the database and will give you a set of menu tabs on the top.

Backup WordPress Database Manually

On the left side click the Select All link and make sure the SQL button is ticked. In the main menu make sure only the following boxes are checked in the top SQL Options section:

  • Structure
  • Add DROP TABLE
  • Add AUTO_INCREMENT
  • Enclose table and field names with backquotes

In the middle Data section only check the Data box and make sure all other boxes are not checked. In the lower Save as file section make sure the Save File As box is checked and tick the “zipped” button. Now just click the lower right Go button and save the file on your computer.

That should get your WordPress database safely backed up and on your computer. To import it just follow these steps in reverse making sure the same settings are selected in phpMyAdmin as outlined when making the backup.

Related Tags: Backups Database Backup Manual Backup Restore

FacebookTweetPinLinkedInEmailPrint

Related Stories

  • WP Custom Fields usage for Customers website and Multisite users

  • How To Make A Sitemap Page For WordPress

    How To Make A Sitemap Page For WordPress

  • Why and How To Turn OFF Disqus Comments on Custom Post Types

    Why and How To Turn OFF Disqus Comments on Custom Post Types

Avatar of Editorial Staff

Editorial Staff

Editorial Staff at WPArena is a team of WordPress experts led by Jazib Zaman. Page maintained by Jazib Zaman.

Reader Interactions

Share Your Thoughts Cancel reply

Before submitting your comment, we kindly ask that you read our comment policy. Your email address will remain confidential and will not be published or shared anywhere. If you subscribe, you will receive notifications regarding new comments.

Primary Sidebar

Automatic WordPress Upgrade

Does The Automatic WordPress Upgrade Work On Your Hosting

WordPress Multisite Shared Media

WordPress Multisite Shared Media Review

Recent Topics

  • Official Windows 7 Wallpapers
  • How to secure your WordPress images and content from Theft
  • Top 20 Web Designing Companies in the World
  • WP Rocket Review: Is It the Perfect Solution for WordPress Caching?
  • The Complete WordPress Security Guide 2023 – Step by Step

Footer

Top

  • Services
  • Our Themes
  • Facebook
  • Twitter
  • Linkedin

Reviews

  • Beaver Builder Review
  • Beaver Themer Review
  • WP User Frontend Pro
  • Ninja Forms Review
  • MemberPress Review

More Reviews »

Resources

  • Best WordPress Plugins
  • WordPress Permalinks Structure
  • Email Management System
  • Envato Free Files
  • Advertise
  • Write for us
  • Disclosure
  • Terms
  • Privacy
  • Contact

Copyright © 2023 · All Rights Reserved · WPArena is a Project of TechAbout LLC.
We are not affiliated with Automattic or WordPress.

  • Advertise
  • Write for us
  • Disclosure
  • Terms
  • Privacy
  • Contact
Share this ArticleLike this article? Email it to a friend!

Email sent!