Monthly Archives: June 2016

How to Export and Import Database in phpMyAdmin

INSTRUCTIONS

Method 1 – phpMyAdmin

Export

  1. Select your database from the list on the left.

    phpMyAdmin_selectDB

  2. Click on “Export” from the top set of tabs.

    Phpmyadmin_export

  3. Select the tables from the list that you would like to back up. If you want to back up the entire database, click “Select All.”

    Phpmyadmin_export_select_all

  4. Make sure both the “Structure” and “Data” boxes are selected on the right. They should be, by default.In the Structure section, check the “Add DROP TABLE / DROP VIEW” box if you want this export to be able to replace existing tables of the same name. If you want to merge this backup with another database, do not select this.

    Phpmyadmin_export_structure_data_drop_table

  5. Check the “Save as file” box. Also select a compression option (such as “gzipped”) if you want to compress the backup before downloading it from the server.

    Phpmyadmin_export_save_file

  6. Click the “Go” button, and, at the prompt, save the file to your local computer.

    Phpmyadmin_go

Import

  1. Make sure the database you need has already been created. If it has not, please first create the database:

    CAUTION:

    If you import a backup file to a database that already has content, it will replace the existing content.

  2. In phpMyAdmin, select your database from the list on the left.

    phpMyAdmin_selectDB (1)

  3. Click on “Import” from the top set of tabs.

    Phpmyadmin_import

  4. Click on the “Browse” button next to “Location of the text file.”

    Phpmyadmin_import_browse

  5. Browse to your local SQL file and click “Open.” If it is a zipped file, please unzip the file first.
  6. Click the “Go” button at the bottom. Wait while your database imports. Depending on the size, this can take a few minutes.

    Phpmyadmin_go

    You should get a message like this:Import has been successfully finished, X queries executed.

    If you instead receive an error, please try the command line method below.

A4JP.COM DESIGN

Copyright © 2019