Hostgator connect to server via SSH or Shell on Mac.

First you need to create a support ticket or contact support to enable shell access. Then, open up your terminal app and type ssh -p 2222 You use your cPanel login credentials to access the server. via How Do I Get and Use SSH Access? « Support Portal.


MySQL SSH Export and Import Database in Shell Terminal

In your favorite shell you can export a MySQL database and Import using the following. on Ubuntu, my MySQL databases are located at /var/lib/mysql/database_name To Export a MySQL Database run: mysqldump -v -u username -p database_name > dumpfile.sql To Import a MySQL Database run: mysql -v -u username -p database_name < dumpfile.sql