空白目錄 · SCRM微擎版升獨立版數據遷移操作指導

## ！！注意：數據遷移過程中，不要登錄系統，遷移完成再登錄； ``` ``` #### **【注意】微擎版根目錄下的uploads文件遷移到獨立版根目錄下；** **1、微擎版根目錄：/www/wwwroot/項目目錄/addons/worldidc_scrm/scrm/public；** **2、獨立版根目錄：/www/wwwroot/項目目錄/public；** ![](https://img.kancloud.cn/75/a4/75a4d99ff5a8fe1787dc2808bd191a15_1893x877.png) ![](https://img.kancloud.cn/72/b8/72b85a442851f3eb842e200d9b21f6fd_1884x801.png) **1、選擇微擎數據庫，點管理，查看crm的數據庫；**? ![](https://img.kancloud.cn/c1/b6/c1b608f48b6c61d375f4334f29238b7b_1913x921.png) ? **2、微擎版SCRM數據表導出方式選擇：自定義；如下圖，將scrm開頭的表除了scrm\_node表全部勾選；** **【注意】導出微擎數據庫的時候不要選中scrm\_node表；** ![](https://img.kancloud.cn/bf/ef/bfef9f192ca774e96afd36974a2ea05a_1820x936.png) ![](https://img.kancloud.cn/b7/39/b73921644120f607c1eac4b7e27925fa_1652x847.png) ? **3、新建的獨立版數據庫清空掉除了【scrm\_node】表的數據；** **【注意】清空獨立版數據庫的時候，不要清空【scrm\_node】表；** ![](https://img.kancloud.cn/fc/3d/fc3de2d9963a32e13d25b2abcd6078c3_1900x929.png) ? **4、選擇安裝獨立版的數據庫，點管理，查看crm數據庫，點導入；** #### 選擇上一步導出的文件，「執行」導入即可； ![](https://img.kancloud.cn/f7/1d/f71d790d0f0434fe6c152e2fdde05b9c_1680x900.png) ? **5、獨立版數據庫導入數據完成后，執行如下SQL語句；** **【登陸獨立版SCRM后臺注意項】** **1、沒有遷移微擎版SCRM數據庫到獨立版，獨立版默認的系統登錄賬號密碼：admin??123456** **2、已遷移微擎版SCRM數據庫到獨立版：** ?????（1）沒有執行下面的數據庫語句，除微擎總管理員賬號密碼，其他的微擎操作員賬號密碼都可以登錄； ?????（2）執行了下面的數據庫語句，獨立版默認的系統登錄賬號密碼：admin??123456 **以下是執行語句，語句較長，請復制完整；** ``` delete FROM `scrm_department_worker` where account='admin'; INSERT INTO `scrm_department_worker` (`account`,`password`,`user_name`,`department_num`,`state`,`role_id`,`customer_id`,`user_num`) VALUES ("admin","$2y$10$PFZIP.w797UC/5OJLRd6Y.Dfa2e0x5H.wHIlkbG809hBsbvfcuxM2","admin","world_1","1","99999",1,"world_1"); update `scrm_role` set `node_info` = '[{\"id\":44},{\"id\":45},{\"id\":304},{\"id\":46},{\"id\":47},{\"id\":48},{\"id\":49},{\"id\":50},{\"id\":51},{\"id\":52},{\"id\":53},{\"id\":54},{\"id\":55},{\"id\":56},{\"id\":57},{\"id\":58},{\"id\":59},{\"id\":60},{\"id\":61},{\"id\":62},{\"id\":63},{\"id\":64},{\"id\":65},{\"id\":66},{\"id\":67},{\"id\":68},{\"id\":69},{\"id\":70},{\"id\":71},{\"id\":74},{\"id\":75},{\"id\":76},{\"id\":77},{\"id\":78},{\"id\":79},{\"id\":81},{\"id\":82},{\"id\":83},{\"id\":84},{\"id\":85},{\"id\":86},{\"id\":87},{\"id\":88},{\"id\":89},{\"id\":90},{\"id\":92},{\"id\":93},{\"id\":94},{\"id\":95},{\"id\":96},{\"id\":97},{\"id\":98},{\"id\":99},{\"id\":100},{\"id\":101},{\"id\":102},{\"id\":124},{\"id\":125},{\"id\":163},{\"id\":164},{\"id\":165},{\"id\":166},{\"id\":167},{\"id\":168},{\"id\":169},{\"id\":170},{\"id\":171},{\"id\":173},{\"id\":174},{\"id\":175},{\"id\":176},{\"id\":177},{\"id\":178},{\"id\":179},{\"id\":180},{\"id\":181},{\"id\":182},{\"id\":184},{\"id\":185},{\"id\":186},{\"id\":187},{\"id\":188},{\"id\":189},{\"id\":190},{\"id\":191},{\"id\":192},{\"id\":193},{\"id\":194},{\"id\":195},{\"id\":196},{\"id\":197},{\"id\":198},{\"id\":199},{\"id\":200},{\"id\":201},{\"id\":202},{\"id\":203},{\"id\":204},{\"id\":205},{\"id\":206},{\"id\":207},{\"id\":208},{\"id\":209},{\"id\":210},{\"id\":211},{\"id\":212},{\"id\":213},{\"id\":214},{\"id\":215},{\"id\":216},{\"id\":217},{\"id\":218},{\"id\":219},{\"id\":220},{\"id\":221},{\"id\":222},{\"id\":223},{\"id\":224},{\"id\":225},{\"id\":226},{\"id\":227},{\"id\":228},{\"id\":229},{\"id\":230},{\"id\":231},{\"id\":232},{\"id\":233},{\"id\":234},{\"id\":235},{\"id\":236},{\"id\":237},{\"id\":238},{\"id\":239},{\"id\":240},{\"id\":241},{\"id\":242},{\"id\":243},{\"id\":244},{\"id\":245},{\"id\":246},{\"id\":247},{\"id\":248},{\"id\":249},{\"id\":250},{\"id\":251},{\"id\":252},{\"id\":253},{\"id\":254},{\"id\":255},{\"id\":256},{\"id\":257},{\"id\":258},{\"id\":259},{\"id\":260},{\"id\":261},{\"id\":262},{\"id\":263},{\"id\":264},{\"id\":265},{\"id\":266},{\"id\":267},{\"id\":268},{\"id\":269},{\"id\":270},{\"id\":271},{\"id\":272},{\"id\":273},{\"id\":274},{\"id\":275},{\"id\":276},{\"id\":277},{\"id\":278},{\"id\":279},{\"id\":280},{\"id\":281},{\"id\":282},{\"id\":283},{\"id\":284},{\"id\":285},{\"id\":286},{\"id\":287},{\"id\":288},{\"id\":289},{\"id\":290},{\"id\":291},{\"id\":292},{\"id\":293},{\"id\":294},{\"id\":295},{\"id\":296},{\"id\":297},{\"id\":298},{\"id\":299},{\"id\":300},{\"id\":301},{\"id\":302},{\"id\":303},{\"id\":305},{\"id\":308},{\"id\":309},{\"id\":310},{\"id\":311},{\"id\":312},{\"id\":314},{\"id\":315},{\"id\":316},{\"id\":317},{\"id\":318},{\"id\":319},{\"id\":320},{\"id\":321},{\"id\":322},{\"id\":323},{\"id\":324},{\"id\":325},{\"id\":326},{\"id\":327},{\"id\":328},{\"id\":329},{\"id\":330},{\"id\":331},{\"id\":332},{\"id\":333},{\"id\":334},{\"id\":335},{\"id\":336},{\"id\":337},{\"id\":338},{\"id\":339},{\"id\":340},{\"id\":341},{\"id\":342},{\"id\":343},{\"id\":344},{\"id\":345},{\"id\":346},{\"id\":347},{\"id\":364},{\"id\":365},{\"id\":366},{\"id\":367},{\"id\":370},{\"id\":371},{\"id\":372},{\"id\":373},{\"id\":374},{\"id\":375},{\"id\":376},{\"id\":377},{\"id\":378},{\"id\":379},{\"id\":380},{\"id\":381},{\"id\":382},{\"id\":383},{\"id\":384},{\"id\":385},{\"id\":386},{\"id\":387},{\"id\":388},{\"id\":389},{\"id\":390},{\"id\":391},{\"id\":392},{\"id\":393},{\"id\":394},{\"id\":395},{\"id\":396},{\"id\":397},{\"id\":398},{\"id\":399},{\"id\":400},{\"id\":401},{\"id\":402},{\"id\":403},{\"id\":404},{\"id\":405},{\"id\":406},{\"id\":407},{\"id\":408},{\"id\":409},{\"id\":410},{\"id\":411}]' where is_sys_role=1; ``` ![](https://img.kancloud.cn/3b/36/3b360b8670e998980f25a9b720b727e3_1908x566.png)