Seven Internet Support

Import & Export SQL dump via SSH

1. Exporting a MySQL database To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database: mysqldump -uUSERNAME -pPASSWORD DATABASE > backup.sql Make sure you replace USERNAME, PASSWORD and DATABASE

Find Plesk email passwords

Login to the server via the command line and run this command /usr/local/psa/admin/sbin/mail_auth_view If want to have the passwords in a file for later (not a good idea) you can run /usr/local/psa/admin/sbin/mail_auth_view > email-passwords.txt

How to Enable Gzip on Nginx

nano /etc/nginx/nginx.conf Add the following gzip on; gzip_vary on; gzip_proxied any; gzip_comp_level 6; gzip_buffers 16 8k; gzip_http_version 1.1; gzip_types image/svg+xml text/plain text/html text/xml text/css text/javascript application/xml application/xhtml+xml application/rss+xml application/javascript application/x-javascript application/x-font-ttf application/ font/opentype font/ttf font/eot font/otf; Then restart nginx &