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

• How to Import a Large Database via SSH

  You need to have: Access to the cPanel of your hosting account. SSH access enabled (if you don't have it, request it from your hosting provider). The .sql backup file already uploaded to the server (via FTP or through the cPanel File Manager). A ...