How to export Databases in phpMyAdmin

asked Jun 8, 2012 in General by rocky_10 (260 points)
Hi all..
I need instructions on how to export databases in phpMyAdmin, can anyone please advice me what is the simplest way to do this?
Thank you

2 Answers

0 like 0 dislike
answered Jun 8, 2012 by randy999 (4,520 points)
1.First Log into phpMyAdmin.  
2.Then click on ‘database’
3.Select the Export tab for the wanted database.  
4.The Export options will be displayed. Export will automatically create .sql file that can be re-imported into a database server.
0 like 0 dislike
answered Jun 8, 2012 by TopNet (10,360 points)
You can do this by command line. Using SSH login to MYSQL database server  and run the below command
mysqldump -Q databasename -uusername -p > databasename.sql