How to export a database using PHPMyAdmin

How to export a database using PHPMyAdmin, If you are using PHPMyAdmin and want to export a database then navigate to PHPMyAdmin in hosting control panel or in localhost. Login to PHPMyAdmin and select the database which you want to export from left side column, after selecting database then it will show all the tables. On top of it you can see a list of tabs, click on Export tab. Then you will get options to export a table.

If you want to export a database in localhost then navigate to localhost/phpmyadmin or if you are on web server navigate to server’s phpmyadmin then login to phpmyadmin with login credentials.

  • After Logging into PHPMyAdmin, select the database from left side column.
    How to export a database using PHPMyAdmin, If you are using PHPMyAdmin Step One

    How to export a database using PHPMyAdmin, If you are using PHPMyAdmin Step One

  • On top you can see list of tabs click on Export after selecting a database.
  • On export screen, you can see these options for quick export select this option “Quick – display only the minimal options”

    How to export a database using PHPMyAdmin, If you are using PHPMyAdmin Step Two

    How to export a database using PHPMyAdmin, If you are using PHPMyAdmin Step Two

  • If you want advanced options to export database like selecting specific tables, then you can use this optionCustom – display all possible options. And it has lot of other options.

In advanced options, you can select the file format to export database. And other options like whether you want to export database with table data or without table data.

Incoming search terms:

  • how to export database to phpmyadmin in one com
Vivek Vengala
 

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply:

x

Join My Facebook Group to Receive Coding Tutorial for Free

email-subsribe