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

PHP version change

The PHP version is changed in the hosting control panel. How do I open the hosting control...

Database import or export via SSH

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

Creating a Mail Domain

Mail domain is a collection of mailboxes linked by one domain name. Each mailbox has an email...

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...

Domain Name Creation

Domain Name System (DNS) is a mechanism designed to search the host's domain name for its IP...