• Abigail November 8, 2017
    how-to-migrate-wordpress-database

    This article helps you to understand how to migrate wordpress datasbase.
    This article consists of following things:

    1. Why i need to do so?
    2. How can i do it myself without impacting web site.
    3. Difficulty Level {Easy, Medium, High} 
    4. Total Time Consumed 
    5. Related Plugins

    Why i need to do so?

    If we want to transfer a database from one server to another server then it is very easy by importing and exporting database.There are no need to create database again. we can use already created database by importing and exporting. So it is important to Migrate WordPress Database.

    Steps needed to migrate database:

    1:Log in your cPpanal
    Step1: type your user name
    Step2: Type your Password
    Step3: Click on Log in

    Cpanal login
    After Login open cPanal Window look like:
    Go to Database Section and click on phpMyAdmin

    cpanal

    Open a phpMyAdmin Window look like:

    PhpMyAdmin

    Exporting a Backup of your WordPress Database

    Step1: Click on Export
    Step2: Check box Custom-display all possible options
    Step3: Select All Database tables
    Step4: Go to format and set SQL
    Step5: Go to Object Creation Options
    Step6: Check box Add Drop Table/View /Procedure/Function/Event/Trigger Statement
    Step7: Click on Go

    Export Database
    After clicking go a .sql file download on your local machine on downloaded folder.

    Creating a NEW MySQL Database

    Open cPanal
    1:Go to DATABASE Section and click on MySQL Database

    Database in cpanal
    3: Create New Database
    Step1:  Write Database Name(my_db1)
    Step2: Click on Create Database
    Create new database
    Then get a message (added the database).Click on Go Back.
    Successful message
    4: Add New User:
    Step1: Write Username(anju)
    Step2: Type Password
    Step3: Retype Password
    Step4: Click on Create User
    Add New User in database
    Now you get a message(Successfully created a MySQL user).Click on Go Back.
    Successful message
     5: Add User to Database
    Step1: Select user by drop-down menu
    Step2: Select database by drop-down menu
    Step3: Click on Add
    Add user to database
    After that Manage User Privileges
    Step1: Check the box All Privileges
    Step2: Click on Make Changes
    Manage user privlleges
    You get a message(requested privileges on the database).Click on Go Back
    Successful message
    Now you can see your database and user create successfully.
    Current Database
    Current users

    Importing the Backup you Created

    Step1: Go to  cPanal and click on phpMyAdmin
    Step2. Click to import on your database.

    Import database

    Step3. Then choose file ( to locate the SQL file on your computer.)

    Choose file

    Step4. After making sure you have ‘SQL’ selected under ‘Format’  You will see your chosen database file is appear then click Go button.

    upload .sql file

    Now successfully migrate your wordpress database.

    C. Difficulty Level

    Medium

    D. Total Time Consume

    45

    E. Related Plugins

    No
    Summary
    How to migrate wordpress database?
    Article Name
    How to migrate wordpress database?
    Description
    If we want to transfer a database from one server to another server then it is very easy by importing and exporting database.There are no need to create database again. we can use already created database by importing and exporting. So it is important to Migrate WordPress Database.
    Author
    Publisher Name
    WordPress Support
    Publisher Logo

    Leave a comment.

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

    error: Content is protected !!