Import and Export of Database Data

Data can be imported and exported using a dump. Database dump is a text file that contains the structure and data of the database. It can be used as a database backup or to transfer a database from one server to another.

Export



To export data from a database, go to Tools → Databases → Download. The browser will prompt you to select a directory for saving the file or save it to a directory for downloads.



To import data into a database from a local computer:

Go to Tools → Databases → Upload.
Select a File Type: Click Ok.

  • File from local computer - select Local file;
  • File URL on another server - Specify the URL.
  • 174 Users Found This Useful
Was this answer helpful?

Related Articles

Database import or export via SSH

Often, it is more convenient to import and export databases not through the phpMyAdmin interface,...

Guide for setting up MX record (example Google)

MX records are DNS records required for routing email. The MX record dictates which mail servers...

Adding a domain to hosting

Adding a domain to an existing hosting takes place in the control panel 1. In the "WWW" section,...

Adding Self Signed SSL Certificate

Attention ! This method of installing an SSL certificate is not the easiest and fastest, for a...

Quick and easy installation of an SSL certificate

For a quick installation of an SSL certificate, we will use Let’s Encrypt.Let’s Encrypt is a...