When you want to insert larger CSV file in to a mysql database using  PhpMyadmin or any other GUI tools it may take long time or even it  may be stopped. You can easily Import the CSV file in to mysql database using mysql command.  Log on to the server and  open mysql command and [...]

I have seen that when executing a mysql query the cpu usage becomes 100 % and it takes a long time to execute the query.  I have executed the same query thorugh phpmyadmin and that time also it took a long time to execute also mysql consumes 100 % cpu .  I have done some [...]

Install mysql server on both server and client machine
Settings in Server
Editi My.conf
log-bin = mysql-bin
server-id = 1
binlog-do-db=DBNAME1
binlog-do-db=DBNAME2
# Backing up Master Database
mysqldump -u root -p –routines –add-drop-table –master-data –databases DBNAME1 DBNAME2 > master.sql
musql -uroot -p
CREATE USER ‘repluser’@’%’ IDENTIFIED BY ‘password’;
GRANT PROCESS , SUPER , REPLICATION SLAVE , REPLICATION CLIENT ON * . * TO ‘repluser’@’%’ IDENTIFIED BY [...]