i have a linux server on TP.

and not have CP only use ssh.

i can use ftp download sites data.
i do not know how to download mysql.
about 20 sites,how can i use ssh download all 20 sites mysql to my PC.

thanks.

Create a dump of the mysql databases and then download it via ftp. The utility you want to look at is mysqldump. For usage see 'mysqldump --help'.

Hi,

cd /var/lib/mysql

cp -R * /home/username

Now use ftp to download all the databases and delete them after the downloads.


or

make a tar or zip of all the 20 sites dbs and put it in your home directory and download it.

Use this command to dump all databases:

mysqldump --all-databases -u root -ppassowrd > /home/username/databasedump.sql

This way you can create mysqldump backup and download it now .