Sometimes, you want to remove the replication , it could be because the replication no longer works, or you don’t want to replicate. Here are some commands that you can use Login to mysql: mysql -uroot -p Enter your mysql root password Run the following command to disable the replication with master. STOP SLAVE; RESET SLAVE; change master to master_host=”, master_user=”, master_password=”; On the master, if you want to disable the replication you should login to mysql and run : stop master Delete all .bin file in /var/log/mysql Edit /etc/my.inf and remove the replication sectionRead More →

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 →