For dumping a mysql database we can use mysqldump utility comes with mysql. Go to mysql bin directory and try:
mysqldump dbname -u username -p password > path/to/file
# backup of a table in database
mysqldump dbname tablename -u username -p password > /path/to/file
and for loading same database on another server , login into mysql and run following queries
create dbname;
use dbname;
source path/to/file;

Recent comments
4 days 9 hours ago
5 days 2 hours ago
1 week 1 day ago
4 weeks 3 days ago
16 weeks 5 days ago
17 weeks 2 days ago
18 weeks 1 day ago
20 weeks 5 days ago
30 weeks 2 days ago
42 weeks 5 days ago