Learn cPanel

Controlling your Web Hosting Account has never been that easy thanks to cPanel web Control Panel!

• Last Updated: 04/28/2020
• ( 4 minutes reading )

How to import a Database using phpMyAdmin?

Introduction

The phpMyAdmin feature offers many utilities to the users, and a very significant one is the “Import” option. It can be used to efficiently migrate a website’s database when you have the SQL file at your disposal or create a staging version of your website. In this tutorial, we will teach you how to use phpMyAdmin to import an SQL file in a database you already created. If you are not sure how to create a database, we have great tutorials on the matter.

 

Accessing phpMyAdmin

Before you can access the phpMyAdmin functionality, you need to log into your cPanel account with us. To do so, please check our tutorial on How to access the cPanel service.

Once logged in, please navigate to the “Database” section and click on the “phpMyAdmin” icon. 

 

Access phpMyAdmin



Clicking on the result redirects you to the “PHPMyAdmin” feature. In the left sidebar, you can see a list of all your databases.

 

Importing a Database

Please select the newly created database the SQL file should be imported within.

 

Database List




To access the “Import” functionality, please click on the “Import” tab, located at the top toolbar.

 

Access Import tab

 

When you land on the “Import” page, you can see a few sections. Let’s go over them so you can get a better understanding of all the available settings:

 

File to import section

Under the “File to Import” section, you can see the “Choose File” button. When you click on it, a popup window appears, allowing you to select a file. This file can be an SQL file XML file, CSV file, or an archived file containing the same, such as a gzip, bzip2, or zip compressed archive. 

Once the file is selected, phpMyAdmin uploads it and imports all the tables within the selected database. You may also use the drag-and-drop method to drag the file from your computer on the phpMyAdmin import screen to start the process.  

Note that you may not select a file larger than 50MB. This limit is implemented to prevent the importation of large SQL files containing slow and unoptimized queries, which can result in a dramatic drop in performance on the entire server. If your SQL file or archive is above the limit, you would need to either reduce it or import it via SSH.

 

Select file to import

 

The last option you have under this section is the “Character set of the file” dropdown menu. You may use it to select a charset of the file you are about to upload. In most cases, you should leave it at the default utf-8.

 

Partial import section

As phpMyAdmin is written in PHP, it can utilize every PHP settings on the server, and the timeout limit is one of them. 

 

Enabled Database import timeout detection

 

Putting a tick inside the checkbox allows phpMyAdmin to interrupt the import process if it detects that it is nearing the timeout limit. This is useful when uploading larger files. However, it can cause MySQL to store the results of partial operations(failed transactions).

The text field underneath lets you set a number of SQL queries you want phpMyAdmin to skip during the import process.

 

Other options:

In the “Other options” section, you can see only one checkbox. It allows you to either enable or disable foreign key checks during the import.

 

Enable foreign key checks

 

Format section

In the “Format” section, you can select the format of the file you are about to import - for example - SQL, XML, or CSV.

 

Select database import format

 

Format-specific options section

The last section on this page is the “Format-specific options” section. This allows you an even deeper tunning on the format of the specific file you are about to import. Using the dropdown menu, you can select a specific SQL compatibility mode if you are importing a file generated on a server utilizing an older MySQL version, for instance.

Putting a tick inside the checkbox underneath this dropbox allows you to disable the AUTO_INCREMENT statement for zero values. Unticking it, enables the statement for zero values.

 

Format-specific options

 

After you are done setting up the import settings, please press the “Go” button on the bottom left side of the screen. 

 

Initiate Database import

 

This starts the importation process. and when it is done, you are going to receive a success message. 

 

There you have it! The import option inside the phpMyAdmin service simplified! If you are facing any technical issues with it or you are unable to import a specific file yourself, please feel free to contact our Support Team! They are 24/7 available at your disposal through the ticketing system on our website.

 

 

...
Sebahat
Content Marketing Specialist

Sebahat is a young and bright woman who has become an invaluable part of our team. She started as a Customer Care Representative, mastering that role and, along the way, growing into a tech-savvy individual who is well acquainted with every support layer of the company. Driven by her aim to improve our customers’ experience constantly, she is committed to enhancing the extraordinary support we deliver.