How to replace the website domain name in Imperial CMS

The method to change domain names in batches for Empire cms entire site columns and content web links is as follows:

1 , Preparation work:

The official domain name change steps given by the empire are as follows:

(1) Set the parameter setting options.

(2) Replace the corresponding field value:

Method 1: Run update phome_ecms_news set titleurl=REPLACE(titleurl,'Original domain name','New domain name') (Explanation: news is the corresponding table)

Method 2: Just replace field values in batches in the background

2. Then transfer the backed up data to the new space according to the official website migration method provided by the empire. . After the transfer, remember to update the data on the entire site. After the update, the data should be restored. However, there may be problems such as the image not being displayed, the image path being incorrect, and the paths in the text not being equal. At this time, you need to perform step (2) in 1.

3. Replace the corresponding field value:

There are 2 methods:

The first method: Go to "Website Backstage - System Settings - Backup" /Restore data - execute sql statement" run update phome_ecms_news set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic,'Original domain name','New domain name')

Note: After executing this statement, only the value of the news table in the empire cms database is replaced. Just in case, it's a good idea to do this for all eight tables in the empire cms.

So in addition to executing the above statement, you should also execute the following 7 statements:

update phome_ecms_download set titleurl=REPLACE(titleurl,'original domain name','new Domain name'),titlepic=REPLACE(titlepic,'Original domain name','New domain name')

update phome_ecms_photo set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic =REPLACE(titlepic,'Original domain name','New domain name')

update phome_ecms_flash set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic, 'Original domain name','New domain name')

update phome_ecms_movie set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic,'Original domain name', 'New domain name')

update phome_ecms_shop set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic,'Original domain name','New domain name')

update phome_ecms_article set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic,'Original domain name','New domain name')

update phome_ecms_info set titleurl=REPLACE(titleurl,'Original domain name','New domain name'),titlepic=REPLACE(titlepic,'Original domain name','New domain name')

Execute The above statement may report an error, but you can ignore it because not every table will have the field titleurl or titlepic. Just make sure that the above code you enter is syntactically correct.

The 2nd method:

(1) Enter "Website Backstage - Column Management - Other Management - Batch Replace Field Values";

(2) You will see that there are eight tables inside. All we have to do is to perform the following operations on each table inside:

A. Select a table in "Select Replacement Table", and then select all in "Operation Fields" (select multiple fields You can use CTRL/SHIFT);

B. Write your original domain name in the "Original Characters" of "Replace Content", and write your new domain name in the "New Characters";

C. Select "Regular Replacement" and finally submit.

Recommended:Empire cms website building tutorial

The above is the detailed content of How to replace the website domain name in Imperial CMS. For more information, please follow other related articles on the PHP Chinese website!