How to backup MySQL database using PHPMyAdmin

The are a few way to backup the MySQL database. One of the easiest way is using the phpmyadmin. This only applicable for the database that was installed with phpmyadmin such as LAMP server, Wamp server and XAMPP server. Most of the students or for the development peoples has using this phpmyadmin to administer their database because it’s easy to use and it help us to reduce the common mistakes. Please follow this step to backup the MySQL database.

1. Go to this url:

    http://localhost/phpmyadmin/

In the real webhosting, “localhost “should be appear as

    http://myexample.com:2082/cpsess57339117932/3rdparty/phpMyAdmin/index.php


2.Select Export Menu and select which database to backup or migrate.

READ  How to Download and Install Angry Birds on Android Smart Phone

3. At the bottom of the page, select check box “Save as file”, the rename the file such as “wordpress_db.” Make sure that you select the compression type is “zipped” Click Go to proceed.

4. The backup mysql db will be name as “wordpress_db.sql”. Make a copy of this file. We will use this .sql file to import . Proceed to restore MySQL database using PHPMyAdmin.

Leave a Reply

Your email address will not be published. Required fields are marked *

SiteGround.com

A world leading hosting company that provides fully-managed innovative and secure solutions, suitable for hosting small to medium-sized websites

Built on the best available technologies combined with Google Cloud for strong redundancy and application availability. Backed by skilled experts to address web security threats, a devops team to create advanced custom security solutions, and 24/7 sysadmins to watch over the platform. This powerful, hands-on approach makes your sites faster, safer, and easier to manage. Starting from only $3.95/mo.

TRY FREE

* up to 30 days money back guarantee