How MySQL Select Max Value
Fetch Row with Max Value On an online shopping website, we'd like to show visitors the most recent items added to the table items, which… Read More »How MySQL Select Max Value
MySQL
How MySQL Execute SQL File
Just like we said in the previous post: How to Backup MySQL Database, mysqldump exports a set of executable SQL statements that can recreate the… Read More »How MySQL Execute SQL File
Mysqldump Compress on the Fly
Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »Mysqldump Compress on the Fly
Gurantee Unique for a Long Text Column
You may have known that unique index on a string-typed column has limitation on prefix length, which can't guarantee that uniqueness is working properly if… Read More »Gurantee Unique for a Long Text Column
Change innodb_buffer_pool_size Online
If you'd like to raise innodb_buffer_pool_size without restarting mysqld, you can set the variable at run-time. The size unit is in byte. mysql> set global… Read More »Change innodb_buffer_pool_size Online
mysqldump Remote Database to Local One
Remote to Local For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel… Read More »mysqldump Remote Database to Local One
How to Resolve SQLSTATE[HY000] [1040] Too many connections
MySQL Too many connections Recently, I saw some blank pages on my website without any error, especially when the web server was very busy. I… Read More »How to Resolve SQLSTATE[HY000] [1040] Too many connections
MySQL Backup Stored Procedures
Procedures and Functions By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable… Read More »MySQL Backup Stored Procedures
MySQL Set Root Password
Before MySQL 5.7 For the first time to reset root password before MySQL 5.7, you set the new password by mysqladmin: On Windows.C:\Users\ed>mysqladmin -u'root' password… Read More »MySQL Set Root Password
MySQL Regular Expression Replace?
For string processing, the databases can not perform as good as middlewares. For example, you may see every kind of regular expression related functions equipped… Read More »MySQL Regular Expression Replace?