How SQL Developer Connect MySQL
SQL Developer + MySQL By default, SQL developer can be used to connect only Oracle databases. As you can see, there's only Oracle tab in… Read More »How SQL Developer Connect MySQL
MySQL
How to Fetch Max Value in MySQL
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 to Fetch Max Value in MySQL
How to Execute SQL File in MySQL
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 to Execute SQL File in MySQL
How to Backup MySQL Database
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 »How to Backup MySQL Database
How to Make a Long Text Column Unique
You may have known that unique index on a string-typed column has limitation on prefix length, which can't guarantee the uniqueness if the length of… Read More »How to Make a Long Text Column Unique
How to 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 »How to Change innodb_buffer_pool_size Online
How to Migrate Local Databases to Remote Host or Vice Versa Without Dump Files
For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel without intermediate dump… Read More »How to Migrate Local Databases to Remote Host or Vice Versa Without Dump Files
How to Resolve MySQL 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 MySQL Too many connections
How to Backup MySQL Data and Stored Procedures
By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable the backup by… Read More »How to Backup MySQL Data and Stored Procedures
How to Set or Reset MySQL 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:Usersed>mysqladmin -u'root' password… Read More »How to Set or Reset MySQL Root Password