Heart+Soul Design Studio

Custom Wordpress development, maintenance and security. Home of the AHA! Academy.

  • start hereHome
  • get the deetsAbout US
    • Disclosures
    • Privacy
    • Service TOS (Terms of Service)
  • email us hereProject Inquiry
    • Client ♥
  • read onThe Blog
  • get the goodsShop
    • Migrations
    • Plugins
    • Services
    • Site Security
    • Cart
    • My Account
    • Checkout
    • Shop TOS & Refund Policy
  • our recommendedResources

Join the Newsletter

Get Tips · Tricks & Goodies
right in your inbox!

It is strongly recommended that you backup your database at regular intervals and before an upgrade.

[swf]https://heartandsoulco.com/wp-content/uploads/2011/03/backup.swf[/swf]

This video shows the basic steps to making a backup through your cpanel of your entire site (all files and folders). This backup CANNOT be used by you to restore your site through CPANEL but you should keep the back up file locally (on your own external hard drive) for your own records.(the demo shows saving to a remote server, save to your home directory and download, then remove it)

The backup feature can be used to backup your MySql database. Do not generate a full backup, as these are strictly for archival purposes and cannot be restored via cPanel. Look for ‘Download a MySQL Database Backup’ and click the name of the database. A *.gz file will be downloaded to your local drive. The backup of the database will only be available here, once its been created.

To Back Up your data base using PHP-MyADMIN

    1. Log into phpMyAdmin on your server
    2. From the main login screen, select ‘Databases’

(You may not need to do this step)Image:podz_backup_1.jpg

    1. Now click the name of your database – or your WordPress database if you have several databases.

(Your screen may look slightly different, depending on the version.)Image:podz_backup_2.jpg

    1. The next screen will show you all the tables inside your WordPress database.
      Ignore those, and click the ‘Export’ tab on the top set of tabs.

Image:podz_backup_3.jpg

    1. Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.
      • If you have other programs that use the database, then choose only those tables that correspond to your wordpress install. They will be the ones with that start with “wp_” or whatever ‘table_prefix’ you specified in your ‘wp-config.php’ file.
      • If you only have your WordPress blog installed, leave it as is (or click ‘Select All’ if you changed the selection)
      • Ensure that the SQL radio button is selected.

Image:phpMyAdmin_backup_export.png
Image:Phpmyadmin_bentrem.jpg

    1. The SQL section
      • ‘Structure’
      • ‘Add DROP TABLE / VIEW / PROCEDURE / FUNCTION’
      • ‘Add IF NOT EXISTS’
      • ‘Add AUTO_INCREMENT’ and
      • ‘Enclose table and field names with backquotes’

Tick the following boxes:

    1. The DATA section

It doesn’t matter too much what you check here. So long as you check the DATA box itself, the Complete inserts and Extended Inserts are mostly cosmetic changes to the output style, though Extended Inserts can help if you are having issues with the file size.

    1. Tick the ‘Save as file’ option, and leave the template name as is.

Image:podz_backup_5.jpg

  1. Now click ‘Go’ and you should be prompted for a file to download. Save the file to your computer.
    Depending on the database size, this may take a few moments. (For most databases its a good idea that the ‘gzipped’ radio button be clicked.) gzip is a highly compressed file.
  2. You have now backed up your database.

USING PHPMYADMIN, is easy and quick. However, you can blow your entire database out of the water if you’re not careful! If you need this done for you, we’re happy to take care of backing up your database and downloading it to our drive, please contact us for pricing the service.

Tweet
Share
Pin
Reddit
Flip
Pocket
0 Shares
  • Facebook
  • Instagram
  • Pinterest
  • Twitter

sovrn Holdings, Inc.

Get A Leg Up On Your Competition

SEMrush

Hello You Designs - Designer Quality Wordpress Themes
The owner of this website, Heart+Soul Studio, is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking Heart+Soul Studio to Amazon properties including, but not limited to, amazon.com, endless.com, myhabit.com, smallparts.com, or amazonwireless.com.

Categories

  • Tips and Tricks
  • Bloggers
  • SEO & Content Development
  • Code Snippets
  • Security

The Shop

  • Shop
  • Cart
  • Checkout
  • My Account
  • Shop TOS & Refund Policy

Get Social

  • Twitter
  • Facebook
  • Pinterest
  • Instagram

The Links

  • Home
  • The Blog
  • Shop
  • Client Praise
  • Project Inquiry
  • Email
  • Facebook
  • Instagram
  • Pinterest
  • Twitter

Copyright © 2025 · Heart+Soul Design Studio · Made With ❥ In Louisiana

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.