Export Database

Hello Friends Forums WordPress Support Export Database

Tagged: 

This topic contains 4 replies, has 2 voices, and was last updated by  Edward Walk 1 year, 8 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #153

    Edward Walk
    Participant

    How can I exporting my Database from my previous host?

    #154

    Antony Clerk
    Participant

    The process to export your database contains 4 key steps:

    1. Locate and access your database on your current host.
    2. Select your database.
    3. Configure your custom export.
    4. Export and save the database locally.

    #155

    Edward Walk
    Participant

    Thanks, but can you explain me step 3.?

    #156

    Antony Clerk
    Participant

    Once you have selected the correct database, click on Export in the top navigation menu.
    Next, you will be provided with options for the Export Method.
    Select Custom. This will show additional export options.
    From the Tables box, click Select All to ensure that all of the tables are exported. Scroll further down the options list to the Format heading.
    Then pick SQL as the export format.
    In the Object Creation Options subsection, select the following check boxes:
    Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
    CREATE TABLE statement
    CREATE TABLE Options
    IF NOT EXISTS
    AUTO_INCREMENT
    Enclose table and field names with backquotes
    The final piece to consider is Maximal Length of Created Query, which is found at the bottom of the Export page.
    For databases over 300MBs I highly recommend you alter the Maximal Length of Created Query to 1047551.

    #157

    Edward Walk
    Participant

    Thank you so much!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.