how to import local sever database to live server database

Welcome to designers blog here i have posted how to  import local sever database to  live server

database in wordpress


Step1:

Export the database from local server phpmyadmin - databasename -  themes

Step2:

 Go to live server - Create new - new Database name - which is start with prefix  Cre8tive_

so we have to give our new database with name called Cre8tive_webdeal

 Step3:

We have to create the username and password for the database

 Step4:

Add user to database selecting in drop-down menu and add

Step5:

Make sure all the privileges tick and  click make changes

Step6:

Go to PhpMyAdmin u will see the added database name - Cre8tive_webdeal

Step7:

Now you have to import the database  themes to live server

 live server database name is Cre8tive_webdeal  and the local database is themes so there is

major different in case you upload it  will get fail


Step8:

To import the local database to live server u have open the export file themes.sql  in the notepad

 or Dreamweaver  editor and change the database  : cre8tive_webdeal


--
-- Database: `cre8tive_webdeal`
--
CREATE DATABASE IF NOT EXISTS `cre8tive_webdeal` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `cre8tive_webdeal`;

Now u can import the file successfully


Step10: 

Changing the Site URL

Now you need to change the site URL, so you can setup your live WordPress site. In your

phpMyAdmin, look for the wp_options table in your database that we just imported in step 4. If you

 changed your database prefix, then instead of wp_options it might be {prefix}_options.

Click on the browse button next to wp_options or the link that you see in the sidebar to open the

page with a list of fields within the wp_options table. See screenshot below:

Under the field options_name, you need to look for siteurl. Click the Edit Field icon which can be

found at the far left at the beginning of the row.

When you click the edit field, an edit field window will appear. In the input box for option_value,

you will see the URL of your local install probably something like: http://localhost/test.

Carefully insert your new site url in this field, for example: http://www.wpbeginner.com Save the

field by clicking the Go button.Next, you need to replicate this step for the option name: home. The

wp_options page can be a few pages long, so simply find the home tab. Usually it is on the second

page which you can navigate to by clicking on the pagination arrows in phpMyAdmin.

Update the home url to be the same as your siteurl.


Step10:

You have to change the WP-config file since you have upload or install WordPress form your local

server files.

Open the Wp-config file and change the

1.define('DB_NAME', 'cre8tive_webdeal'');

2. define('DB_USER', 'cre8tive_web');

3.define('DB_PASSWORD', 'web123');

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'cre8tive_webdeal');

/** MySQL database username */
define('DB_USER', 'cre8tive_web');

/** MySQL database password */
define('DB_PASSWORD', 'web123');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Step11:

Now Access the Live url  you will see the similar local server files

Enjoys folks .........................