MySQL Server gone away while inserting or deleting
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16M
Read more
MySQL
MySQL : Introduction to MySQL
Birth Of MySQL MySQL started out with the intention of using the mSQL database system to connect to tables using fast
Read more quickly copy MySQL InnoDB database without using MySQL dump
For this process We should noted that there must have the same architecture on both machines. I.e. if we have 32 bit on
Read more mysqli_connect() – function php mysql db connect
The mysqli_connect() function opens a new connection to the MySQL server. Syntax: mysqli_connect(host,username,password,dbname,port,socket); Parameter Description host Specifies a host name
Read more show progress on MySQL DB Import
You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with: yum
Read more Remove duplicate rows in MySQL
Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement,
Read more MySQL Cluster Overview
MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the
Read more Setting of Resource Limit of MySQL User-Account
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a
Read more MySQL User Names and Passwords – MySQL Security
MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a
Read more Client Programming Security Guidelines – MySQL
Applications that access MySQL should not trust any data entered by users, who can try to trick your code by
Read more