How to export mysql database and restore using SSH

First login your server using SSH. Then run following command mysqldump -u dbuser -p dbpassword dbname | gzip > dbname.sql.gz Change dbuser, dbpassword and dbname with your database user name, password and database name. If you want to restore the database on another server. Then we need to copy exported database on another server. We … Read moreHow to export mysql database and restore using SSH