database

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;