There are various method to setup multiple of mysql instances on a single linux ubuntu server. In this scope of this page, i will show you the most simple one. You can follow the steps below to get it done: 1. Create separate data and log directories We need to create new directories for our datadir and log folder (if used). Also we need to assign proper permissions on those folders: mkdir /var/lib/mysql2 chown -R mysql.mysql /var/lib/mysql2/ mkdir /var/log/mysql2 chown -R mysql.mysql /var/log/mysql2 2. Create a new mysql configuration file Next we need a separate configuration file. We can start by copying the existing one andRead More →

error_reporting = E_ALL & ~E_NOTICE => PHP will stop if we have any error related to E_DEPRECATED , it may not show you any warning – very silent – different to debug , this is when we use some old function. error_reporting = EALL & ~E_NOTICE & ~ E_DEPRECATED => it will skip the error and let you continue to run.Read More →

My OS crash today and i had to reinstall mysql server. I am using Windows 2003 (quite old  😉 There are a few things happen when i reinstall the mysql , and it happens at the “instance” configuration step. 1. Canot find my-template.ini , => Fix: copy my-template.ini to bin/ directory 2. Can not start service It’s because the mysql path in Services is not correct : C:\Program Files\MySQL\MySQL Cluster 5.5\bin\bin\mysqld” –defaults-file=”H:\Program Files\MySQL\MySQL Cluster 5.5\bin\my.ini”  MySQL => open registry , go to HKLM \ System\Current Control Set1\ Services Locate mysql , and update the path => Try to restart , if you still can notRead More →

Svnx doesnt have interface to switch the svn repository from one url to another. If you change your url , or move your repository to a new url you can do this. Open the terminal Using “cd” command to go to your repsoitory , e.g. cd /Users/yourname/websites/abc.com (abc.is your svn) then run the command svn switch –relocate old_url new_url if you want to check your old url , you can run the command “svn info”Read More →

DriverIdentifier is a desktop/webapp hybrid—install the program then launch it to scan your system for all device drivers then the program checks to see if there are new drivers available for your hardware on the web and these results are displayed in a browser tab. Any needed driver updates can be directly installed by clicking on the Update link. The program is relatively straightforward. Running it on my Lenovo laptop resulted in a handful of drivers that need updates such as my webcam, graphics card, and SATA controller. Clicking on the update link takes you to a page with several mirror sites from which youRead More →

I just tried this today , it’s really good , you can start with a free plan. This plan allows you to have upto 10 questions per survey and 100 responses. Try it: http://www.surveymonkey.comRead More →