<<
DROP TABLE IF EXISTS `documents`;
CREATE TABLE IF NOT EXISTS `documents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`content` text NOT NULL,
`date_added` datetime NOT NULL,
`author_id` int(11) NOT NULL,
`group_id` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;—
— Dumping data for table `documents`
—INSERT INTO `documents` (`id`, `title`, `content`, `date_added`, `author_id`, `group_id`) VALUES
(1, 'Best April Fools' Bombshell: Google to Acquire Baidu for $30 Billion', 'According to foreign media reports, Google will acquire Baidu in a deal worth up to $30 billion, allowing Google to re-enter the mainland Chinese market. The report states that Google and Baidu have already reached an acquisition agreement and will announce it publicly at an opportune time. Baidu's management team will be retained 100%, but projects will be scaled back, including the Youa marketplace and the currently underperforming Phoenix Nest PPC system. The video site qiyi.com, currently in beta testing, will receive more YouTube resources. (YouTube is temporarily inaccessible in mainland China due to content review issues). This news appears to have been confirmed by Google CEO Eric Schmidt, who expressed it on his Twitter account with a brief, ambiguous message: “Withdraw from that market? u''ll also see another result, just wait… ” The implication is clear: that market refers to mainland China, and the other result, corresponding to this media report, is the acquisition of Baidu to curve back into the mainland search market. At the recently concluded Shenzhen IT Leaders Summit, Baidu's Robin Li remarked, “Google hasn't left China, because it's still in Hong Kong.” This also seemed to hint at the acquisition. As of press time, Baidu's stock price was $597, giving it a market cap of $20.7 billion. Google's offer of $30 billion represents an actual premium of up to 50%. With Google's market cap at $179.6 billion and significant cash reserves, such a decision is within the realm of possibility. Recently, many media outlets have reported on Baidu founder and CEO Robin Li's two rejections of acquisition offers: one was on the eve of Baidu's IPO, when Li refused a buyout from Google, a detail first disclosed on the CCTV dialogue program's first Year of the Tiger episode on February 28; the other was in Baidu's internationalization strategy, where he rejected overseas M&A in favor of a self-developed path starting from the Japanese market. This prompted the author to reflect on the development path of national brands. Acquisitions are a common tactic to suppress Chinese brands. On February 28, 2010, CCTV's economic channel program “Dialogue” aired its first episode of the Year of the Tiger, featuring Baidu Chairman and CEO Robin Li. For the first time, Li discussed the secret conversation he had with Google CEO Eric Schmidt, who secretly visited Baidu on the eve of its 2005 IPO. The main topic was dissuading Baidu from going public, a “kind offer” Li resolutely refused. Looking back today, Schmidt might have had an ominous premonition that this small company of a few hundred people would one day become a major threat. The broadcast of this “Dialogue” episode sparked industry discussion. There are countless examples of foreign brands suppressing Chinese brands through acquisitions. Looking at the Chinese brands acquired by multinational companies, very few are truly allowed to survive, either being shelved or positioned as low-end. Therefore, Baidu's refusal of Google's acquisition in 2005 and insistence on independent development played a crucial role in protecting a Chinese brand and safeguarding the information security of Chinese netizens. Baidu's current market share is as high as 76% and continues to grow, fully validating the correctness of Robin Li's decision to reject the acquisition. Today, “Baidu it” has become a way of online life for over 300 million Chinese netizens. Looking around the globe, only four countries truly have their own independent search engines, like China does! We might be thankful for Robin Li's choice back then. This story also tells us that Chinese companies must rely on themselves to build their brands! Overseas acquisitions could also be a trap for Chinese companies going global. At the same time, on February 28, at the 10th Yabuli Annual Conference, Li pointed out at a forum: “Our internationalization path is very different from many other companies. We are not buying a foreign company.” Li explained the reason for choosing Japan as Baidu's first overseas target: its geographic proximity as a close neighbor, its market size, and the lack of a dominant search engine. The goal for Chinese companies acquiring foreign brands is to “borrow a boat to go to sea.” Foreign brands entering China target premium Chinese brands, but the acquisition strategy for Chinese companies entering foreign markets is the exact opposite, which is why these attempts often fail. In the author's opinion, Chinese internet companies must rely on their own development to go global, not simply on acquisitions. Robin Li has been determined for Baidu to go international since its inception, making the company more calm and forward-looking when truly facing international opportunities. Li also admitted that Baidu is still in an early development stage in Japan but predicted that “in 2012, Baidu and Google will divide the internet landscape along the Pacific,” a claim we wait to verify!', '2010-04-01 22:20:07', 1, 2),(2, 'Twitter Homepage Redesign Promotes Ordinary User Tweets and Trending Topics', 'April 1 news, according to foreign media reports, Twitter launched a new homepage on Tuesday with a simple goal: to help new users understand Twitter and increase user stickiness. The new Twitter homepage entry is visually busy, with a scrolling section of trending topics below the header and a list of ordinary user accounts with their latest tweets on the left. Another prominent section is “Top Tweets,” which uses a new algorithm to select the hottest tweets, refreshing every few seconds. Twitter Chief Scientist Abdur Chowdhury stated that this algorithm picks messages from all users, not just those with a large number of followers. The homepage is extremely important for first-time visitors as it determines their first impression. Research shows that up to 60% of Twitter users do not revisit the site within a month of registration. Twitter hopes to better showcase the site's features and help visitors find things of interest.', '2010-04-01 23:25:48', 1, 3),
(3, 'Must Try at All Costs! A First Look at the Opera Mini Trial Version', 'Opera has always been considered a speed king in browsing and holds a significant share on mobile platforms. Not long ago, Opera officially submitted the iPhone-specific Opera Mini to Apple. Recently, a Taiwanese IT website published a comparison review between Opera Mini and Safari. Let's see which one is better, more user-friendly, and faster. Opera Mini VS Safari: Display Methods Are Quite Different. Unlike Safari, Opera Mini adjusts web pages for the mobile phone. The operating principles of Opera Mini and Safari differ. Web pages are fully compressed through Opera's servers before being sent to the phone. Unlike Safari, which allows free zooming via Multi-Touch and taps, Opera Mini pre-adjusts text width to fit the iPhone screen and zooms in only after tapping a specific area. If you are accustomed to Safari's browsing style, it can feel a bit awkward. However, for many web pages that are too wide and still show small text after zooming, Opera Mini's display method has an advantage. The difference in data consumption for loading the test website homepage is clear between Safari and Opera Mini. Given the high mobile data charges domestically, Opera Mini is likely to be more popular and cost-effective. Opera Mini's data usage is shockingly low, only a tenth of Safari's. In terms of compatibility, Safari wins hands down. Opening the Google homepage, Safari shows the iPhone-specific interface, while Opera shows a generic mobile version. Opera Mini's speed and data-saving capabilities still cannot replace Safari as the primary browser on the iPhone. After all, the iPhone's high penetration means many websites and online services have designed dedicated pages for Safari. Just using Google's homepage as an example shows a clear difference. Additionally, online apps like Google Buzz can experience display errors. In Google Buzz, Opera cannot input content. Other exclusive Opera Mini features: In-page search and direct keyword search are quite user-friendly. Besides the original Speed Dial nine-grid quick launch page and Opera Link, which syncs bookmarks and Speed Dial settings with the desktop Opera, Opera Mini can also search for text directly within a page, which is very convenient when looking up information. You can also select text to open a new tab search, which is much simpler than Safari's copy, new page, and paste routine. It can also save an entire page package for offline browsing. There is still one serious issue left before Opera Mini can beat Safari: when, or if, Apple will approve Opera Mini's App Store submission.', '2010-04-01 12:01:00', 2, 3);
1. Download Sphinx
wget http://sphinxsearch.com/files/sphinx-2.1.5-release.tar.gz
Or go directly to the Sphinx official website to download the latest version. 2. Install dependency packages
yum install make gcc g++ gcc-c++ libtool autoconf automake imake mysql-devel libxml2-devel expat-devel3
Install Sphinx
tar zxvf xpr.gz
cd sphinx-2.1.5-release./configure –prefix=/usr/local/sphinx
make
make installvi /etc/ld.so.conf
/usr/local/mysql/lib # Add this line and save
/sbin/ldconfig -v 4. Configure Sphinxcd /usr/local/sphinx/etc/
vi csft.conf
source mysql
{
type = mysql
sql_host = 10.10.3.204
sql_user = root
sql_pass = dsideal
sql_db = test
sql_port = 3306
sql_sock = /usr/local/mysql/mysql.sock
sql_query_pre &bsp; = extern
mlock = 0
min_word_len = 1
charset_type = utf-8
charset_table = U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z,A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6,U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101,U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109,U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F,U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, U+0116->U+0117,U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D,U+011D,U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, U+0134->U+0135,U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, U+013C,U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, U+0143->U+0144,U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, U+014B,U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, U+0152->U+0153,U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159,U+0159,U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, U+0160->U+0161,U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, U+0167,U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, U+016E->U+016F,U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175,U+0175,U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, U+017B->U+017C,U+017C, U+017D->U+017E, U+017E, U+0410..U+042F->U+0430..U+044F, U+0430..U+044F,U+05D0..U+05EA, U+0531..U+0556->U+0561..U+0586, U+0561..U+0587, U+0621..U+063A, U+01B9,U+01BF, U+0640..U+064A, U+0660..U+0669, U+066E, U+066F, U+0671..U+06D3, U+06F0..U+06FF,U+0904..U+0939, U+0958..U+095F, U+0960..U+0963, U+0966..U+096F, U+097B..U+097F,U+0985..U+09B9, U+09CE, U+09DC..U+09E3, U+09E6..U+09EF, U+0A05..U+0A39, U+0A59..U+0A5E,U+0A66..U+0A6F, U+0A85..U+0AB9, U+0AE0..U+0AE3, U+0AE6..U+0AEF, U+0B05..U+0B39,U+0B5C..U+0B61, U+0B66..U+0B6F, U+0B71, U+0B85..U+0BB9, U+0BE6..U+0BF2, U+0C05..U+0C39,U+0C66..U+0C6F, U+0C85..U+0CB9, U+0CDE..U+0CE3, U+0CE6..U+0CEF, U+0D05..U+0D39, U+0D60,U+0D61, U+0D66..U+0D6F, U+0D85..U+0DC6, U+1900..U+1938, U+1946..U+194F, U+A800..U+A805,U+A807..U+A822, U+0386->U+03B1, U+03AC->U+03B1, U+0388->U+03B5, U+03AD->U+03B5,U+0389->U+03B7, U+03AE->U+03B7, U+038A->U+03B9, U+0390->U+03B9, U+03AA->U+03B9,U+03AF->U+03B9, U+03CA->U+03B9, U+038C->U+03BF, U+03CC->U+03BF, U+038E->U+03C5,U+03AB->U+03C5, U+03B0->U+03C5, U+03CB->U+03C5, U+03CD->U+03C5, U+038F->U+03C9,U+03CE->U+03C9, U+03C2->U+03C3, U+0391..U+03A1->U+03B1..U+03C1,U+03A3..U+03A9->U+03C3..U+03C9, U+03B1..U+03C1, U+03C3..U+03C9, U+0E01..U+0E2E,U+0E30..U+0E3A, U+0E40..U+0E45, U+0E47, U+0E50..U+0E59, U+A000..U+A48F, U+4E00..U+9FBF,U+3400..U+4DBF, U+20000..U+2A6DF, U+F900..U+FAFF, U+2F800..U+2FA1F, U+2E80..U+2EFF,U+2F00..U+2FDF, U+3100..U+312F, U+31A0..U+31BF, U+3040..U+309F, U+30A0..U+30FF,U+31F0..U+31FF, U+AC00..U+D7AF, U+1100..U+11FF, U+3130..U+318F, U+A000..U+A48F,U+A490..U+A4CF
min_prefix_len = 0
min_infix_len = 1
ngram_len = 1}
indexer
{
mem_limit = 256M
}
searchd
{
listen = 3312
listen = 3313:mysql41
log = /usr/local/sphinx/var