MySQL dump through SSH

MySQL dump is very useful though its work directly on server through SSH. It cannot make your site down when exporting database. Here is the key how to do this,


mysqldump --opt -u username -p database_name| gzip > filename.sql.gz

Advertisements