How to export database and tables with phpMyAdmin

 

Export Database and Tables: Many times we run into a requirement when we have to export few tables from a database. Now it could be for sharing that information with someone else.

 

We assumed that you have already logged in into cPanel.

Or click here to see how to login to cPanel.

 

Steps (Export Database and Tables):-

  • Click phpMyAdmin icon.
  • Click the database or table you want to export.
  • Click Export.
  • Choose Export Method.
  • Select the format type as per your need (Like: SQL, PDF, XML) .
  • Select options carefully. Then click go.

That’s it. The database or table has been exported successfully.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to run SQL queries on a database with phpMyAdmin

SQL queries: SQL stands for Structured Query Language. SQL is used to communicate with a...

How to create tables in a database with phpMyAdmin

  Create Tables: The harder part is deciding what the structure of your database should be:...

How to modify fields in database tables with phpMyAdmin

  Modify Fields: To make changes in the existing fields we use the modify options. We assumed...

How to copy a database table with phpMyAdmin

  Copy a database table : Several times, we need to copy SQL Server table schema and data from...

How to delete tables from a database with phpMyAdmin

Delete Tables: Sometimes you need to delete a table; for example, you might want to implement a...