Table of Contents
Exporting a Database from phpMyAdmin the basics
Is it phpMyAdmin or mySQL?
The difference between these two is that mySQL is a database server with command tools and phpMyAdmin is the webapplication for mySQL.
So in short they’re the same.
I’ve made 2 short guides to export and import a database in mySQL / phpMyAdmin.
And 2 long guides for the same thing, but step by step with screenshots.
Scroll down to the appropriate guide.
Short guide – Export MySQL database phpMyAdmin
- Open your cPanel
- Find the phpMyAdmin button
- Select the database you would like to export
- Click Export
- Select Quick as Export method.
- View the Settings
- Select the appropriate format
Click Go
The selected database will be exported and downloaded.
Short guide – Import MySQL Database phpMyAdmin
- Open your cPanel
- Find the phpMyAdmin button
- Browse to the Import file
- View the Settings
- Select the appropriate format
- Click Go
The selected database will be imported.
Long guide – Export MySQL database phpMyAdmin
- Go to your webhosting login page
- Open your cPanel
- Find the phpMyAdmin button.
- Open phpMyAdmin. See the screenshot:
- Select the appropriate Database
- Click on Export
- Select Quick if you don’t know what you’re doing
- Choose the appropriate format, again: if you don’t know what you’re doing select SQL
- Click Go to export the Database.
Exporting a database is easy, but importing a database is just as easy or maybe even easier.
Long guide – Import MySQL database phpMyAdmin
- Go to your webhosting login page
- Open your cPanel
- Find the phpMyAdmin button.
- Open phpMyAdmin. See the screenshot:
- Click the Import button
- Browse to the appropriate file
- Select utf-8
- Don’t uncheck the Partial Import
- Select the appropriate format: default is SQL
- Click Go
That’s it. If you need more help please comment below.