...] [php] ./Indexer.php --source=mysql://root:root@localhost/blog --sql="select b.bid,b.content AS bc,b.addtime,b.title,c.content AS CC from blog b,comment c where b.bid = c.bid" /usr/local/xunsearch/sdk/php/app/59n.ini [/php] [code] [XSException] ../lib/XS.php(2202): Connection timed out(C#...
.../php/util/Indexer.php --rebulid --source=mysql://u:p@127.0.0.1/test --sql="SELECT movie_id,movie_name,movie_starring,movie_director,movie_description,movie_list_img_url,movie_insert_time FROM movie" --project=movie [XSException] ../../usr/local/xunsearch/sdk/php/lib/XS.php(2202): Connection r...
...l/Indexer.php --rebuild --source=mysql://root:123456@127.0.0.1/test --sql="select * from pw_record" --project=record 以上是默认mysql 端口号为3306 导入命令 但是, 现在我的mysql 端口号是6630 在--source=mysql://root:123456@127.0.0.1/test 这块应该如何调整呢?...
...thrown /var/www/xunsearch/sdk/php/lib/XS.php 1018 我的查询语句是:SELECT `ID` as _ID,`title` as _title,`Content` as _body,`QuestionTime` as _time,`UserNam` as _user,`tag` as _tag FROM wenti_nr Where `search`=0 若只用sql进行数据库查询能获取到结果,而用xunsearch执行更...
...l://数据库用户名:数据库密码@数据库地址/数据库名 --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 from pw_threads t left join pw_tmsgs tm on t.tid = tm.tid where t.ifcheck = 1 ...
...ndexer.php(195): XSIndex->update(Object(XSDocument)) sql语句: sql="select c.contentid,c.status,b.contentid from phpcms_content c,phpcms_c_news b where c.contentid=b.contentid and c.status=99" 配置文件: project.name = html project.default_charset = utf-8 server.index = 8383 ...
.../php/util/Indexer.php --source=mysql://root:root@192.168.1.700/test --sql="SELECT id, uid FROM test" --project="/var/xunsearch/sdk/php/app/person.ini" 开始批量导入数据 (请直接输入数据) ... 完成索引导入:成功 338 条,失败 0 条 刷新索引提交 ... 以前还好是来...
...l/Indexer.php --rebuild --source=mysql://root:pass@localhost/dbname --sql="SELECT * FROM tbl_post" --project=demo 注:这里的前提是你已经把帝国装在服务器上了"mysql://root:pass@localhost/dbname",这个句段必须得知道root的密码,另外帝国使用的数据库名称,...
...l/Indexer.php --rebuild --source=mysql://root:pass@localhost/dbname --sql="SELECT * FROM tbl_post" --project=demo 注:这里的前提是你已经把帝国装在服务器上了"mysql://root:pass@localhost/dbname",这个句段必须得知道root的密码,另外帝国使用的数据库名称,...
...用util/Indexer.php --source=mysql://aaa:aaa@192.168.0.2/bbs_test --sql="select * from cdb_posts" --project=discuz 这个命令进行导入的,不知道能否有一个从断点继续的方法?