Tagged: mysql

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...

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;...

[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...