Tagged: mysql

0

Exporting mysql data using mysqldump

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases...

0

How to create,import and export database on MySQL

This article mainly describes the MySQL commonly used commands. Create a database mysql -u root –p #Access to mysql service Enter password: # Enter the root password of the database. MySQL [(none)]> create database ddos;...

2

[How-to-fix] mysql ERROR 1040 (00000): Too many connections

[root@ddos ~]# mysql -u root -p Enter password: ERROR 1040 (00000): Too many connections [root@ddos ~]# vi /etc/my.cnf max_connections=1000 max_user_connections=300     [root@ddos ~]# service mysqld stop Shutting down MySQL…. [root@ddos ~]# service mysqld...