Export and import MySQL databases

  • Plugin Author DivaVocals

    (@divavocals)


    8 years ago

    Doing a basic Google search I found instructions for importing and exporting mySQL databases: https://www.google.com/search?q=how+to+import+mysql+database&ie=utf-8&oe=utf-8

    These instructions are adapted from some of the results found.

    You may export or import data from your MySQL database using phpMyAdmin. A link to phpMyAdmin can be found in your hosts control panel (cPanel or Plesk depending on your hosting package).

    Finding phpMyAdmin in your Control Panel (BASIC cPanel and Plesk Instuctions)
    =========================================================================
    cPanel

    • Login to cPanel.
    • There will be an icon for phpMyAdmin in the Databases section. This will take you to phpMyAdmin.
    • The list of available databases will be listed on the left hand side once you get into phpMyAdmin.

    Plesk

    • Login to Plesk.
    • Click on the Website & Domains tab at the top.
    • Click on Databases in the list of functions.
    • Click on the database you wish to access.
    • Click on WebAdmin in the Tools section.
    • phpMyAdmin will open to the screen for administrating the database you selected.

    Export Your Database
    ======================

    • Select your database from the list on the left.
    • Click on “Export” from the top set of tabs.
    • 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.”
    • 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.
    • 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.
    • Click the “Go” button, and, at the prompt, save the file to your local computer.

    Import A Database
    =================

    • In phpMyAdmin, select your database from the list on the left.
    • Click on “Import” from the top set of tabs.
    • Click on the “Browse” button next to “Location of the text file.”
    • Browse to your local SQL file and click “Open.” If it is a zipped file, please unzip the file first.
    • Click the “Go” button at the bottom. Wait while your database imports. Depending on the size, this can take a few minutes.
    • You should get a message like this:
      “Import has been successfully finished, X queries executed.”

    https://wordpress.org/plugins/zen4wp/

  • The topic ‘Export and import MySQL databases’ is closed to new replies.