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.