How to MySQL import database, and how to MySQL import SQL file through your phpMyAdmin. This is what we're going to learn how to make a successful MySQL import for a new database file.

How to MySQL import database file

First of all you should be logged in your server control panel to MySQL import database file process. You should have a Database or Create a database in the first place before MySQL import database file to your phpMyAdmin. It's not so many steps to MySQL import a Database.

What is the purpose of MySQL import a database?

Any of application needs a storage to add data, database is the most important part of your application, Because it's kinda the storage of your data. Database stores everything happens inside your website or application and getting it back while needed.

 

MySQL import SQL file and other types

there's a list of available types and formats you can import to MySQL database, They're listed when you're trying to import your file.

  • SQL
  • XML
  • ESRI Shape file
  • OpenDocument spread sheet
  • Media Wiki Table
  • CSV

But you can still add you MySQL import database file with a better way, You can compress your SQL file into (ZIP) and import it. And it works.

phpMyAdmin

Go to your phpMyAdmin and login if it needed to be logged in (Happens with WHMCS Panel, Not common with cPanel).

On the left Sidebar, Click on your Database Name. and wait until it loads.

there's no data in database

You got to be sure it's empty to make no conflict while importing a new file. Then Click Import.

how to import a new database

You should now head to File to Import section and click on choose file button, After selecting your (.SQL) or (.zip) file. Click on Go. and wait for importing database.

mysql import sql file

You can also get more information about databases here

How to MySQL import database file
How to MySQL import database file

What is the purpose of MySQL import a database?


{{comments.length}} Comments

{{comment.name}}

{{comment.name}} · {{comment.created}}

{{sc.name}}

{{sc.name}} · {{sc.created}}

Post your comment

64x64
Reply to {{parent.name}} close

Similar Stories


web

Website

What is a website is, What is the difference between the web app and websites, The website ideas you can use or create? The WWW the relations between them and the web app. Learn more about the websites by reading the articleWeb / WebsiteA website or web…

subject Read
Database

Brightery

Brightery Wiki The easy way to get any information about brightery company. Brightery Logo Brightery changed the logo more than once, for improving the experience of clients. Brightery logo 2015 Brightery's first logo was designed 2015, it was reflecting the circle of integration to make…

subject Read
web

Sitemap

What is a sitemap, And what is the usage of website sitemap, Why they're using sitemap xml files to crawl pages. And why google sitemap is great protocol for site map ?SitemapTo define what is site map (Also known as sitemap) is a list of pages included in website to…

subject Read