TECHiE TALKS

    I installed Apache, MySQL and PHP on windows 7.  I tried to install drupal version 7.9 and went through an error as shown in the image below: The error “Your web server does not appear to support any common PDO database extensions.” can be fixed by following these steps: Open your php.ini file Around line 966 uncomment the line “extension=php_pdo_mysql.dll” Make sure you have php_pdo_mysql.dll on your ext folder or download it here php_pdo_mysql Restart Apache and you can [...]

I created a web application that managers collected links.  The web application was called duplicate checker where premium links collected are being stored in a mysql database.  Previously they are doing it on an excel file which automatically highlights the duplicate entry but as months pass by the file is running so slow and so I came up to a solution which is the duplicate checker. Its been almost 5 months and the system was running without any problem, its [...]

My friend forgot his mysql password and the database needs to be accessed by the root user.  My friend is running MySQL 5.1 and as I browsed the MySQL manual the solution provided is not working though a slight change was made.  Just like the provided step in the manual: Log on to your system as Administrator. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager: [...]

Knowing the right MySQL statement is the most important part in having thousands of data in your database, one false move and you can’t undo things.    If you want to change a string or character in your database and doing it manually in thousands or millions of entries then that should consume all of your time. One example scenario is when you want to change all the entries containing a character ‘_’ to this character ‘-’ .  All you need [...]