Tag: mysql

shape
shape
shape
shape
shape
shape
shape
shape
Standard

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 There should be a part of the file that looks like the example below: [mysqld] safe-show-database innodb_data_file_path=ibdata1:10M:autoextend datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock   Add the following variable below

Standard

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 with the user of your database and the name of the database. Below is a video lesson explaining the process:  

Latest news

Latest news directly from our blog.