• How To Backup Your WordPress MySQL Database Using PhpMyAdmin

    by  • July 6, 2013 • wordpress • 2 Comments

    This is usually the 1st step before migrating your wordpress site to a new server, transferring it to a new domain, or for simple backup reasons. It’s highly recommended to backup your database as frequently as possible.

    Log into PhpMyAdmin

    In some hosts, it’s easier to log into your main control panel and then find the PhpMyAdmin icon. Below is what Hostgator’s cPanel looks like:

    php-my-admin-cpanel

    Looking under the “databases” section might help as well.

    Select the Database to Export

    Within PhPMyAdmin’s left nav you’ll find a list of your server’s databases. Select the one you want to export by simply clicking on it.

    php-my-admin-db

    If you have more than one database and are not sure which is the correct one, you might want to FTP into your site and open a file called /wp-config.php – all your database details are stored there.

    Click “Export”

    Section by Section:

    Click for higher resolution.
    php-my-admin-db-export

    1 – Choose “Custom” under Export Methods

    2 – Select ALL TABLES

    3 – Save Output to a file

    4 – Choose SQL under “Format”

    php-my-admin-db-export-drop

    Format-specific settings:

    5 – Check “display comments”

    6 – Dump table “Structure and data”

    7 – Check ALL options under “add statements”

    8 – Check “Enclose table and field names”

    php-my-admin-db-export-go

    Data dump options:

    9 – Select “both of the above” under syntax to use when inserting data

    10 – Check “Dump binary columns in hexadecimal notation”

    11 – Check “Dump TIMESTAMP columns in UTC”

    Save it in a Secure Directory!

    12 – Click “GO”!

    If you’re looking to migrate your site, you’ll then upload your database backup to your new server’s PhpMyAdmin, using the Import function.

    2 Responses to How To Backup Your WordPress MySQL Database Using PhpMyAdmin

    1. Pingback: Creating MySQL Database & Importing Old One Using PhpMyAdmin | LeoSaraceni.Net

    2. Pingback: Migrate Your Wordpress Website In 6 Steps Using PHPMyAdmin | LeoSaraceni.Net

    Leave a Reply