Export A MySQL Database / Back up Big Files via SSH/Putty

[Dev Blaze]

This example shows you how to export a database. It is a good idea to export your data often as a backup.

1. Put The Directory
#cd /root

2.Using SSH, execute the following command:

#mysqldump -p -u username database_name > dbname.sql 

 

 

3. Enter your phpmyadmin Passsword

DONE..

4. Open your winscp check the directory   /root    

[Patskie]

Topic approved!