mysql

Port php mysql scripts to php 7.0 from 5.x version

2018/04/23

Recently I got a script or series of scripts that were written for PHP 5.6x and hence used mysql_connect which as you know by now does not work with PHP 7.0. Since there were number of scripts, I …

Thumbnail

bash debug – log all executed commands

2014/02/03

Whenever I am writing a script in perl or bash, I always wish that there was some way to have all the commands logged or output to screen. I know there is “set -x” option to have debugging enabled, …

Monitor your system with sysusage.

2013/12/02

First some information on sysusage: […] Description : SysUsage continuously monitor your systems informations and generate periodical graph reports using rrdtool or javascript jqplot library. …

phpmyadmin access problem and change server from URL

2012/09/30

I was having issues with one of the phpmyadmin setups. The first server defined in the config file was not accessible and the theme that I was using was not allowing me to change the server from the …

Oracle Select the top 5 queries

2012/02/27

Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.

BASH Script Performace

2012/01/06

Today we will look at some bash code snippests and the performance issues. Lets first look at the problem and the implemented solution: Problem: We needed to log the output of the ps command for all …

Backup of files in the directory.

2011/12/01

I was working on some scripts and the changes that I was making in the scripts was very dynamic, which I did want to keep backing up in the version control system. But for the peace of my mind, I …

mysql output to an array for easy parsing.

2011/05/11

 Today I was looking for some way to put the output of the mysql output in an array in a bash script. Quick google search yeilded to results something like this:  […] <td> <div …

analyze debug queries output for wordpress

2011/02/09

Some time back, my website became too slow and I started getting timeout response for quite a lot of my pages. When I analyzed things, I found the issue was with the DB queries taking a lot of time. …

MySQL tutorial and reference manual

2010/06/25

The refence for the mysql could be found at <a class="aligncenter" title="MySQL Help" href="http://http://dev.mysql.com/doc/refman/5.0/en/index.html" …

Using PHP to search a MySQL database and return paged results

2010/06/25

<a href="http://www.designplace.org/scripts.php?page=1amp;c_id=25">Using PHP to search a MySQL database and return paged results Link above to the article. I am using this as base to …

find duplicate entry in a list in bash with sed

2010/06/25

Here I will take an example of rss2email list, but I guess I will be able to pass on the concept. Here is example of the output of the r2e list command: […] 1: …


This website uses cookies to ensure you get the best experience on our website. Learn more Got it