Site Archives MySQL

Setting up my own RHEL server… again

Posted by plattapuss on May 6th, 2008

If you have followed my story over the past few months, you will know that I got out of hosting. This has been an excellent move over all as it frees up a lot of my time to do what I like best, develope websites and tinker. As I have a fair number of sites [...]

Got the cpanel “Couldn’t find MySQL manager or server” blues?

Posted by plattapuss on November 1st, 2007

With my new cpanel box I just upgraded MySQL 4 to MySQL 5. Then I noticed that MySQL wouldn't start anymore. When I tried to start manually with /etc/init.d/mysql start, I would get this error "Starting MySQLCouldn't find MySQL manager or server [FAILED]". After a quick Google search I found this post with the solution. [...]

MySQLdump to reset Slave server from Master

Posted by plattapuss on December 21st, 2006

Just a quick entry here. I keep forgetting how to reset a mysql slave server from the master, without disrupting the operations on the master server. Something silly that doesn't stick in my head, so I am putting here for future use: If you have Server A with the master, and Server B with the [...]

Replace DB content on the fly

Posted by plattapuss on December 1st, 2005

Use the REPLACE string function to replace DB content the easy way.