how to use mysqldump?

Question

i want to copy my database qdbase server it located at:

qa@qaubuntu:~$ /var/lib/mysql/qdbase

to the client PC, i want it located at:

qa@qadesktop:~$ /home/qa/html

everyone tell me to use mysqldump.how to use that bcoz i never know to use that?

Answer 1

The following is just an example to use mysqldump.

cd /home/qa/html
mysqldump --host="hostname" --user="username" --password="password" databasename > backup_name.sql

Answer 2

Useful examples:

http://www.bukisa.com/articles/409623_how-to-backup-a-mysql-database