How to export your database in phpMyAdmin?

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:

 
- When you are in phpMyAdmin to export your database you must click on the 
 "Export" button, which is located at the top of the page. 

  
- Now choose the "Export Method".
        
  • Fast - show only minimal options. 
    •     
  • Custom - display all possible options. In this option you can choose several 
configurations, such as: Tables, Output, Format specific options, option to 
create objects and data creation options.
    • 

- After all the necessary configurations have been made, click on the "Run" button. 
  
- The download will start.


    • Related Articles

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

    • 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 import a database in PhpMyAdmin?

      Step 1 1 - In cPanel, go to “PhPMyAdmin”; Step 2 In the top bar of your PHPmyadmin click on "Import"; Click the "Choose File or File" button and select your database (.sql); Step 3 Then correctly define the settings you want for import as in the ...

    • How to access PhpMyAdmin in your hosting?

      When hosting with Scriptcase, phpMyAdmin is already installed as standard, you just need to access it through cPanel. See how to access cPanel : Aqui phpMyAdmin is a SQL database manager where you can make changes to your database. - Through cpanel ...