the luxury of invaluable experience.
9 Apr
If you installed a fresh Centos and not selected any package like me, You may need C compiler
try to install use following command
yum install gcc gcc-c++ autoconf automake
cheer!
25 Mar
How to search and replace string in mysql database? You can done with phpMyAdmin, That is a easy way.
To search and replace a text string, start up phpMyAdmin, and click on your database name that you want to run the search and replace through. At the top of the window, click on the “SQL” tab.In the text box, enter the following code. This is the generic setup, so edit to satisfy your needs:
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
You can add a WHERE clause onto this as well.
For example, here is one command a ran:
UPDATE `mos2_content` SET introtext = replace(introtext,"<p>","") WHERE `title` REGEXP '-0';
This got rid of all paragraph tags in the mos2_content table where the title included the string “-0″.
Hope this helps.