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

Creating an Autoresponder

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

Create FTP user

An FTP user is needed to upload or download files to the server via ISPmanager. It only has...

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

Database creation

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