Pace Infonet Web Solutions provides best cheap affordable and reliable windows web hosting in mumbai, windows web hosting in india, windows web hosting in baroda pune delhi ahmedabad, .net web hosting in mumbai, .net web hosting in india delhi, .net web hosting in baroda ahmedabad pune delhi, linux web hosting in ahmedabad baroda pune mumbai delhi, windows vps hosting in mumbai india baroda delhi, linux vps hosting in mumbai india baroda ahmedabad pune delhi, email hosting services in mumbai pune baroda delhi and all over india.

Welcome to Pace Infonet Web Solutions where you can find the best web hosting in india mumbai delhi pune ahmedabad baroda web hosting windows web hosting in mumbai cheap and affordabe web hosting in ahmedabad pune baroda delhi mumbai india web hosting .net web hosting in baroda pune delhi mumbai ahmedabad, windows vps hosting in mumbai delhi pune ahmedabad baroda pune india, linux vps hosting in mumbai ahmedabad baroda india delhi pune and business email hosting in mumbai ahmedabad delhi baroda pune india is also available. Also when compared to godaddy and bigrock our web hosting plans are reliable and affordable than bigrock and godaddy.

How to Restore your MySQL Database using PHPMyAdmin


This article will guide you on how you can restore your MySQL Database on a Web Hosting server. There might be two situations when you may need to use this guide. First is in case you want to Restore to a New MySQL Database or Restore to an Existing MySQL Database.

If you want to Restore to a New MySQL Database then go through the section “a”, otherwise skip to section “b”.

a. Create a New MySQL Database

If you are hosting your web application for the first time under the Hosting Account or want to have a New MySQL Database to be used with your web application, the first thing you need to do is Create New MySQL Database. The steps to create a New MySQL Database differ from one Hosting Control Panel to another.

Below are steps to Create New MySQL Database in Windows Parallels Plesk Hosting Control Panel.

i. Login to your Plesk account. On the Homepage, click on the “Databases” icon from the list.

Restore MS SQL Server

ii. Then click on the “Add New Database” option on the page to get a form. Fill in the database name you desire and also create a database username and password. Make sure you select MySQL in Database Type. Then finally click on “OK” to create the database which will then appear in the list under Databases section.

mysql5aadatabase

For Linux cPanel Hosting Control Panel, the MySQL Database creation process is really simplified by the “MySQL Database Wizard” option available under the “Database” section on homepage of cPanel.

NOTE:You will need to change the Data source/Server name, Database name, Database Username and Database password in your application’s connection String as per created above.

b. Restore your MySQL Database

Once your database is already created, the next step is to launch PHPMyAdmin which is a web based MySQL Database management tool. You can find PHPMyAdmin option under following sections depending upon the Hosting Control Panel you are using.

Parallels Plesk – Go to Databases section from Homepage and click on “Webadmin” link to the right of the Database in the list you want to restore.

mysqlwebadmin

WebsitePanel – Go to Database >> MySQL 5.x section and click on “Browse Database” option to the right of the Database name in the list you want to restore.

cPanel – Click on PHPMyAdmin option under the “Database” section on Homepage of cPanel Control Panel.

Once PHPMyAdmin is open, follow below steps.

i. In PhpMyAdmin, click on the name of your database in Left Sidebar which will take you to your database page. Now there are 2 ways you can restore your database.

ii. Either, click on the “SQL” option in the top horizontal menu to open a text area where you can directly paste the contents of your .sql file (.sql file can be opened in any text editor like Notepad) and then click on “Go” button to restore database.

mysql5Click To SQL

iii. Or, click on “Import” option in top horizontal menu, where you can directly upload your .sql file to restore the database.

mysql5-click-to-import

The time taken to restore may depend upon the size of your sql script file. Also if you are restoring to a Database which already has Table Structures within, then you need to either delete the table first using PHPMyAdmin or need to make sure that “Drop” statement is included in your sql script file when you exported it from PHPMyAdmin on your local computer, another server or from same database for that matter. Also you must make sure that your SQL Script should not include any strongly typed Database Names referring to your local database name or database name of some other server.

You are now ready to use your MySQL Database with your web application.

Related Articles:-

Backup MySQL Database from WebsitePanel Account.

1,670 total views, 3 views today

May 18, 2016
1. Click on the Applications / Menu button on the Home Screen of your Android Device 2. Open the 'Email' Application. 3. Select the Account Type as ...
May 17, 2016
When anyone makes a purchase on our website www.paceinfonet.com, they get registered with us and receive a Welcome Email on their registered email address which ...
 

Need Sales Assistance? CALL : 950-95-77-455 / Chat With Expert

Who We Are

An affordable web hosting company in India- Pace Infonet specializes in offering consistent and cost effective web hosting services in Mumbai and cheap web hosting that comprise of Shared, E-Mail, Reseller, VPS, Dedicated and SEO Hosting for both Windows and Linux. We assure the best, reliable hosting environment, thereby delivering your content very rapidly. Pace Infonet Web Solutions also include .NET web hosting, PHP web hosting, shared web hosting, blog web hosting packages and reseller hosting with varying configurations to be chosen. You can avail of the best options out there in the web hosting marketplace. Learn More…

Top

All web hosting, windows vps hosting, linux vps hosting, business email hosting, dedicated servers in mumbai delhi ahmedabad pune baroda india are provided by Pace Infonet Web Solutions at best cheap affordable prices in india navi mumbai mumbai delhi pune baroda ahmedabad and rest of india. In comparison to godaddy and bigrock our web hosting plans are affordable and reliable than godaddy and bigrock.

Login to Client Area

 

Our Billing & Support Center provides an easy and intuitive way to manage your domains & web hosting services, view & Pay your invoices online and raise your queries to our hosting support departments instantly.

Don't remember your password? Use Password Reset Wizard

X