6

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?

user 99572 is fine
  • 3,397
  • 3
  • 30
  • 43
klox
  • 531
  • 4
  • 9
  • 16

1 Answers1

12

The following is just an example to use mysqldump.

cd /home/qa/html
mysqldump --host="hostname" --user="username" --password="password" databasename > backup_name.sql
ukanth
  • 10,660
  • 11
  • 43
  • 60