How to export mysql database?

There are two ways to export mysql database from your source.

1. phpMyAdmin
2. Command prompt

Export Mysql Database:

     First thing was how to export a database using phpMyAdmin.

 *) Log into phpMyAdmin.

*) select your database from left side database list

*)  Click the Export tab at the top

*)  select the all/required table on right side column and if you want to download as file mean just select the file name and check save as file option in footer.

*) if you only structure of the tables just uncheck the checkbox near data header or if you need the data only just uncheck the checkbox near structure header. select required options options underneath the structure and data header.

*) then click GO button and your database will exported.


if you using phpmyadmin it will take some time and if database have too  much content
(largesize) mean , butter you can use command prompt to export the db, using command prompt we can easily download large database with in few mins

first open mysql command prompt
*) in windows
     if you using wampp just click the icon in taskbar , and select mysql-> mysql console.

*) in unix/ubuntu
     just open the terminal and go to mysql path

Run this command:

mysqldump -h host-u root -p database>destination_path/somename.sql

Technical tags :

export mysql database, export mysql table, mysql command , export database,mysqldump tutorial, phpmyadmin.

i will explain about import database upcoming post

Mysql related books: