...le [content] type = body #导入 php util/Indexer.php --rebuild --source=mysql://数据库用户名:数据库密码@数据库地址/数据库名 --sql="select t.tid as tid, t.fid as fid, t.author as author, t.authorid as authorid, t.postdate as postdate, t.subject as subject, tm.content as content...
...php /usr/local/xunsearch/sdk/php/util/Indexer.php --project=xxx –-source=mysql://xxx:xxx@localhost/xxx --sql="select ID,post_title,post_content,UNIX_TIMESTAMP(post_date) as post_time from wp_posts where (post_status='publish' or post_status='pending') and post_type='post'" Indexer - 索引批量...
...在来创建索引 /usr/local/xunsearch/sdk/php/util/Indexer.php --source=mysql://xxx --sql="SELECT p.ID,UNIX_TIMESTAMP(p.post_date) AS post_date_sec,DATE_FORMAT(post_date,'%Y%m%d') AS post_time,p.post_title,p.post_content,p.post_content AS post_content_full,u.user_login AS author,t.name AS categor...