Skip to content

广告数据

lupeng0512 edited this page Aug 15, 2017 · 1 revision

备份

  mysqldump -uroot -p -S /tmp/mysql-3309.sock molib adcontextual > molib-adcontextual-20150127.sql

更新前确认操作

  • mysql> select count(*) from ad_contextual where brand_id='4018'; //注意更改对应id

  • mysql> select max(id) from ad_contextual where brand_id='4018'; //注意更改对应id

  • mysql> delete from ad_contextual where brand_id='4018'; //注意更改对应id

导入

  mysql -uroot -p -S /tmp/mysql-3309.sock molib < maxim.sql

更新后确认操作

  • mysql> select count(*) from ad_contextual where brand_id='4018'; //注意更改对应id

  • mysql> select max(id) from ad_contextual where brand_id='4018'; //注意更改对应id

更新索引

  /usr/local/coreseek/bin/indexer ad_contextual –rotate -c /etc/coreseek/9312/csft.conf 服务器地址为41

Clone this wiki locally