MySQL Server gone away while inserting or deleting
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16M
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 low-level (ISAM) routines. However, after some testing, They conclude that mSQL was not fast enough or flexible enough. This resulted in a new SQL interface to our database but with almost the same API interface … 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 one server then other server would also have 32 bit. But in case if we have 32 bit on one server and 64-bit on another then we will have to use MySQL dump. mysqldump – … 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 or an IP address username Specifies the MySQL username password Specifies the MySQL password dbname Optional. Specifies the default database to be used port Optional. Specifies the port number to attempt to connect to the … 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 install pv # pv db1.sql.gz | gunzip | mysql -u root -p db1 693MiB 1:00:33 [ 325kiB/s] [====================> ] 68% ETA 0:16:20
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, include the IGNORE keyword. Like so: ALTER IGNORE TABLE jobs ADD UNIQUE INDEX idx_name (site_id, title, company); This will drop all the duplicate rows. As an added benefit, future INSERTs that are duplicates will error … 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 system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. MySQL Cluster is designed not to have any single point of failure. In a shared-nothing system, each … 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 nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. In addition, setting max_user_connections does not … 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 user name and the client host or hosts from which the user can connect to the server. The account may also have a password. There are several distinctions between the way user names and passwords … 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 entering special or escaped character sequences in Web forms, URLs, or whatever application you have built. Be sure that your application remains secure if a user enters something like “; DROP DATABASE mysql;”. This is … Read more