Increasing Max MySQL Connections

To increase the maximum number of connections that MySQL allows, you must edit the '/etc/my.cnf' file. Log in to the server as 'root', and type the following command: vi /etc/my.cnf…
How to Backup MySQL Database with Putty (SSH)

How to Backup MySQL Database with Putty (SSH)

To back up a database using an SSH client, simply use the following command:   mysqldump --opt -Q -u usuário_banco-de-dados -p nome_banco-de-dados > backup.sql   Replace the names in bold…