用户工具

站点工具


差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

两侧同时换到之前的修订记录 前一修订版
后一修订版
前一修订版
后一修订版 两侧同时换到之后的修订记录
en:razor:upgrade-instruction-v0-6-to-v0-7 [2015/09/15 10:05]
cobub
en:razor:upgrade-instruction-v0-6-to-v0-7 [2015/09/15 15:30]
cobub v0.7.2
行 2: 行 2:
 {{description>​Cobub Razor is an Open Source Mobile Analytics. When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:​.}} {{description>​Cobub Razor is an Open Source Mobile Analytics. When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:​.}}
 {{keywords>​Cobub Razor,open source mobile analytics,​mobile analytics,​mobile app analytics, upgrade}} {{keywords>​Cobub Razor,open source mobile analytics,​mobile analytics,​mobile app analytics, upgrade}}
-v0.7.1+ 
 ====== Upgrade Instruction (v0.6 to v0.7) ====== ====== Upgrade Instruction (v0.6 to v0.7) ======
 When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required: When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:
行 1138: 行 1139:
 ('​72417',​ '​Ceterp Cel Brazil',​ '​724',​ '​BR'​);​ ('​72417',​ '​Ceterp Cel Brazil',​ '​724',​ '​BR'​);​
 </​code>​ </​code>​
 +==== 3、Modify the stored procedures ====
 +
 +
 +Stored procedures: **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** and **runweekly** 。
 +
 +Steps:
 +
 +1)you will get  six sql script files under the directory of **assets\sql** of V0.7 :  **sp_rundaily.sql** 、 **sp_rundim.sql** 、 **sp_runfact.sql** 、 **sp_runmonthly.sql** 、 **sp_runsum.sql**
 +and **sp_runweekly.sql**.
 +
 +2) modify table prefix
 +
 +Modify the **umsinstall_** in all sql scirpt files above to your own data warehouse’s table prefix, for example,​your data warehouse table prefix “razordw_”;​
 +
 +Replace the “databaseprefix.umsdatainstall_” to “database.database’s table prefix”, for example, your database is cobubrazor,​and database’s table prefix is razor_,the ”databaseprefix.umsdatainstall_” should be “cobubrazor.razor_“.
 +===== Step three: stop inserting data to database and pause the stored procedures. =====
 + 
 +
 +
 +Note: you need to have prepared all the relevant SQL scripts(i.e. ​ all sql scripts ​ in Step two).
 +
 +
 +===== Step four: delete all stored procedures in data warehouse. =====
 +
 +
 +
 +===== Step five: execute the SQL scripts generated in Step two. =====
 +
 +
 +Note:  Please backup the data of your database and data warehouse before you execute the sql scripts.
 +
 +
 +===== Step six:restart the database and data warehouse. =====
 +
 +
 +Before this step, you need to do the last thing :
 +
 +Backup the directory of the previous web site(e.g **web**,​which is the root directory of version 0.6),store it in a suitable place and named web-backup0.6,​ then delete **web**.
 +
 +Change”razor_v6” ​ to “web”(the name of V0.6),and set $config['​base_url'​]= ‘http://​192.168.1.103/​web’ in **config.php**.
en/razor/upgrade-instruction-v0-6-to-v0-7.txt · 最后更改: 2017/07/14 11:18 (外部编辑)