How to enable mysql_clear_password plugin?

How to enable mysql_clear_password plugin? Read more →

A simple guide to MySQL backup history

Use these MySQL tables mysql.backup_progress    & mysql.backup_history for backup history Read more →

Default Isolation Levels across database systems

Most DBMS systems have a range of isolation levels. Fine line between bugs & deadlocks related to setting isolation levels Read more →

How to MySQL restore files from a directory backup to their original location

Some useful information to do a MySQL restore for a point in time recovery Read more →

How to make MySQL tables case insensitive

Question: I'm working with vendor supplied ddl scripts, which are causing case-sensitive issues. Early in the scripts - there is a CREATE TABLE statement . But further down the script there is an INSERT statement - but the case of the table is lower - causing an error . How can I fix this issue? Answer:To fix this issue - change the "lower_case_table_names" variable . To see the current value of lower_case_table_names use : show variables like '%lower_case_table_names%' To solve this problem - you will need to change the value to "1" . Find the location of the "my.cnf" file... Read more →