Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to copy my database qdbase server. It is located at:

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

On the client PC, I want it located at:

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

Everyone tells me to use mysqldump. How do I use that because I've never learnt how to use that?

share|improve this question
up vote 1 down vote accepted

The following is just an example to use mysqldump.

cd /home/qa/html
mysqldump --host="hostname" --user="username" --password="password" databasename > backup_name.sql
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .