Tag Archives: mysql
Updating Multiple Rows in MySQL
There comes a time when you need to update multiple rows with different values. You can update multiple rows with the same value, but when dealing with different values for different rows, it becomes a difficult task. Yes there are … Continue reading
MySQL Backup Strategy
The Story A few months ago, while at home, my supervisor called me. The incident was that our client’s QR System stops working on a certain module. I learn that the possible cause was a table corruption, so the the … Continue reading
Posted in Database, MySQL
Tagged backup strategy, binary log, innodb, innodb backup, mysql, mysql backup, mysql backup strategy, schedule backup
Leave a comment
MySQL Query – No Quote For String Fields
One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record on the database. It was originally built on MyISAM table … Continue reading
Posted in Database
Tagged index not hit, mysql, mysql index, mysql query, no quote, SQL, sql index
Leave a comment
MySQLDump In Many Many Ways
Again, there is another need to blog this thing. I encountered this situations where dumping the database using default options does not fit the purpose, so today, we will be playing with mysqldump options for making MySQL backup. Simple Backup … Continue reading
Importing Huge CSV File to MySQL via PHP
Yes there are several techniques to import CSV to MySQL. I have encountered this task several times already the those previous experiences worked out seamlessly, but this one is a bit complicated and requires a lot of effort in order … Continue reading
Posted in Linux, MySQL, php
Tagged csv, csv to mysql, import csv, importing huge csv, mysql, php
2 Comments
The way I discovered PHP
I was a VB programmer for 3 years. That was almost two years ago. My obsession was on OpenSource softwares. My first open source software used was SuSE Linux Live Eval 9.1. Then eventually, I installed the SuSE Linux Personal … Continue reading
