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 creation

Database (DB) - a unified repository of textual information of the site. The database stores...

Remote Access for MySQL Server

IntroductionThe MySQL server has the ability to listen on specific addresses to accept incoming...

Creating an Autoresponder

An autoresponder is needed to automatically send a message with a specific text in response to...

PHP version change

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

Domain Name Creation

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