How to import/export a MySQL database

1 - In cPanel, go to “PhPMyAdmin”;

Import:

2 - Click on "Import";

3 - Click the "Choose File or File" button and select your database (.sql);

4 - Click the "Execute" button;

Export:

2 -Choose the database you want to export from the list on the left;

3 - Click the "Export" button and choose one of the options:

Fast: export the entire database using the predetermined options

Custom: allows you to choose which tables to export, also allows you to change the export options.
Below you see images if you select the custom option where you define everything you want manually

4 - After defining everything you want in your export, click the "Execute" button and the download will begin.

• Related Articles

• How to import/export a PostgreSQL database

  Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...

• How to upload a firebird database to your hosting acount

  If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...

• How to export your database in phpMyAdmin?

  To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...

• MySQL Database

  MySQL databases are required to run many web-based applications, such as information dashboards, content management systems, and online shopping carts. Step 1 Logged into your cPanel, in the DATABASE tab, locate the item “Manage My Database” note: ...

• Creating a MySQL Database

  The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "Databases" ...