How to Upload MySQL Database with phpmyadmin

How to Upload MySQL Database with phpmyadmin

Many webmasters who started websitesnya from the local computer by using php and mysql.

The difficulty that often occurs when uploaded to the server mysql database. The following actions should be taken.

That need to be prepared on the local computer is phpmyadmin, phpmyadmin is usually already installed when you install software packages such as WAMP Server, XAMPP and PHP Triad consisting of a package of Apache, Mysql, phpmyadmin.

To export data commonly used facilities 'MySQL Dump' in phpmyadmin.

Two steps are done that is in Local Computer and the Server. If you already have a database in the form of a file just follow the steps on the server.

ALL STEPS BELOW HAS BEEN SUCCESSFULLY TESTED BY THOUSANDS OF PEOPLE, THAT ERROR OCCURRED IN YOUR ORDER TO BE BACK WebSites steps ESPECIALLY IN CONFIGURATION: DATABASE NAME, USER NAME AND DATABASE HOSTNAME

The steps on your local computer:

1. Log into phpmyadmin on your local computer
2. select the database you want to dump,
Located on the left phpmyadmin

3. Phpmyadmin will display the tables contained in the database.
4. click on the 'Export'
5. Now you are on the option that determines the 'How do you be in the dump database',

The default is SQL, and we recommend using SQL.

Sometimes you need to select 'Add DROP TABLE' point to add the SQL to delete the previous table at the time of import on the server.

Another option you can also use the 'Save as File', we recommend using the SQL option.

6. click 'go'

Results dump will be displayed in the browser, then you copy these first results.

To create a mysql database, following the steps in your hosting cpanel:

Login to the cpanel of your website in a new window:

http://www.yourdomain.com/cpanel

replace yourdomain with your domain name.

After logging into your cpanel do the steps below:

If you have not set up MySQL users and databases in cpanel. follow these steps:

1. Click on the 'MySQL database'

2. fill in your username and password on the option 'Add New User' and then click 'Create User'

Mysql user is automatically formed will be preceded and followed by a user cpanel mysql user name that you input. as an example:

usercpanel_namausermysql

3. Enter the name of the database you want to create the 'new database' and click 'Create Database'

Mysql database automatically formed will be preceded and followed by a user cpanel mysql database name that you input. as an example:

usercpanel_databasemysql

4. Add users to the database that you created by selecting 'Add User To Database' and click 'submit'

5. Select ALL PRIVILEGES and click 'Make changes'

From the above we can note two important configurations needed to connect to the database:

1. database name: usercpanel_databasemysql

2. user database: usercpanel_namausermysql

Note:
* mysql database, username and password have been formed for NOTE, because it will be necessary to connect to your database.

* MySQL Server use localhost

you should note from the article above: NAME DATABASE, USER and PASSWORD DATABASE DATABASE
Without all three you know, your website will not be able to connect to the database server.

2. After the database, and user database form, click the icon on the main page of cpanel phpmyadmin (in addition to 'MySQL database')

3. Phpmyadmin will appear, then select the database that you fill with the results of the MySQL dump, located on the left menu.

4.Click on the 'SQL'

Your stay PASTE results mysql database dump from your local computer in the 'Run SQL Query "

5. Finally click 'GO'

It's finished, all the mysql database you've uploaded to the server
Next you just adjust your PHP scripts to connect to the database by changing the configuration database, mysql user and password that has been formed.