Posts under MySQL Database

MySQL: Full text search for multiple words

advertisement

mysqlI notice one of my MySQL full text search result for multiple words doesnt seems correct. After some checking, i realize i don’t know how to do full text search for multiple words! LOL. This is because i use ONLY single words during testing. After go thru the MySQL documentation again, now i get a clear view of how to structure the SQL statement for full text search (multiple words)!

Here are some example for MySQL full text search for multiple words:-

Continue reading MySQL: Full text search for multiple words »

MySQL replication stop at Last Errno 1062

advertisement

mysql, mysql databaseI just setup a MySQL replication at 2 virtual machine. However today i found the replication stop at the slave machine with last_errno 1062. With the error message:-

“Error ‘Duplicate entry ‘2562846’ for key 1′ on query. Default database: …”

My system admin told me that they restarted my machine last nite and i think that cause the mysql replication stop.

How to solve MySQL replication stop at last errno 1062:-

Continue reading MySQL replication stop at Last Errno 1062 »

Common MySQL database maintenance command

advertisement

mysql, mysql databaseThis post is a note for me to remember the common MySQL maintenance command. These MySQL maintenance command (check table, repair table, analyze table and optimize table) is very useful to ensure the MySQL database run smoothly and error free. Understanding these MySQL maintenance command will allow you to perform the right operation at the right time.

Here are the MySQL maintenance command simple brief:-

Continue reading Common MySQL database maintenance command »