...hp/bin/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 - 索引...
...就可以正常导入。 我输入命令符的时候 util/Indexer.php --source=json cusabio_cn_fix /var/www/fix/file1.txt -c gbk 报错误为 WARNING: invalid line #1 - Empty array INFO: reach end of the file, total lines: 1 Íê³ÉË÷Òýµ¼È룺³É¹¦ 0 Ìõ£¬Ê§°Ü 0 Ìõ
...e = title [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 ...
... 现在来创建索引 /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 ...