Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14611 reviews 1734 hosting providers

Questions & Answers

How to export Databases in phpMyAdmin

Jun 8, 2012 by rocky_10
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 votes
Jun 8, 2012 by randy999
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 votes
Jun 8, 2012 by TopNet
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