This is happen long time ago when Mysql Replication stop due to duplicate error, Kumay has the log. But I don’t want to do a manual labor. So to skip a duplicate error on A MySQL Replication Server (SLAVE) automatically. Added this line on /etc/my.cnf
Note: Make sure you know what cause a duplicate error and does it really not important so that you can skip inserting that query.
(more…)
Kusma!!!, Now I know how to make old mysql front ver 2.5 which created on 2002 and using libmysql from mysql 3.23 accessing mysql5 server. I just realized this when Andry complaining and whining can’t access Ivory DB on new server which also mysql5 using his old mysql-front. He said, he can use mysql-front 2.5 accessing Mysql server 5 on his localhost and BOX server.
Now, if I can make sure old mysql-front program accessing mysql server 5 this will make major leap!!!
old zeos component (which also based on libmysql from mysql 3.23) for delphi 5 now can access Mysql 5 server. God know what happen when mysql5 take control, replacing old and dull mysql4. We can make master-master replication, clustering mysql server or make mysql serve faster by running mysql proxy. But it depend on how much the company will spend money for investing on hardware (and pay me of course to execute it)
Kusma, do you want to know how to enable Mysql server 5 to acknowledge old mysql-front program to access it? if so comment to this article please 
From Howtoforge.com’s article: Running MySQL 4 And MySQL 5 Concurrently
But I did in another way, because current release of CentOS / RHEL 5 already include MySQL 5 and I install MySQL 4 manually. I need a server with 2 MySQL version for development purpose: as current development is using MySQL 4 so I’ll configure it to use default port 3306 and for MySQL 5 will use port 3307.
First install CentOS with MySQL 5, afterthat configure MySQL 5 to use port 3307
# cp /usr/share/doc/mysql-server-5.0.22/my-medium.cnf /etc/my.cnf # vi /etc/my.cnf ... [client] #password = your_password port = 3307 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3307 socket = /var/lib/mysql/mysql.sock ... # chkconfig mysqld on # service mysqld start
To add new mysql user you can read “Adding mysql users“, to change mysql’s root password use:
# /usr/bin/mysqladmin -u root password 'newpassword'
Now we are going to install MySQL 4
My friend asked me how to get MySQL running as Windows standalone application. So he can execute the mysql start-up command by putting it inside his application. So every time his application run, it also start up mysql daemon. He doesn’t want MySQL running as service every time Windows starts as someone can access the data from outside his program. So after couple of times trying, here it is.
Note: