Tutorial on how to batch modify database table prefixes in Imperial CMS

Sometimes when we use Imperial CMS to build a website, we did not modify the default database table prefix of the program during the initial installation. So what if we want to modify it to our own later? Next, we will demonstrate how to batch modify the database table prefix in Imperial CMS.

We first use navicat to link the database information, select the database information, and then choose to export the database and structure. See the picture for details (PS: You can also use phpmyadmin to export)

Modify the database prefix

This database file can also be opened and modified using "Notepad" and "Word", but it is not recommended due to encoding problems. It is recommended that you use "Dreamweaver" or EmEditor to modify it, and it will be successful in one try. Here is an example , the default database table prefix of empire cms is phome_, if we need to change it to laoliang_, I will use EmEditor to demonstrate here, open the xxx.sql file, and then replace all, as shown below:

Follow the above steps!

Recommended site searches: Hong Kong server hosting, free virtual host rental space, virtual host, domain name registration center, US space, mainland China domain name, US host reviews, vps dynamic ip server, web page registration,