Simple 3 steps to modify a Dream data table prefix

Source: Internet
Author: User

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Hello, everyone. I am a new contact Dream CMS Novice, today to share how to modify the Dream 6184.html "> Data table Prefix method, (if you have just started to build the station this article will not help you, if your station has been established more than 1 months, the data are quite many. It is also urgent to modify the data table prefix. So this article will be able to help you) well, the nonsense will not say more, please look down. For a more intuitive way to reflect the correctness and usability of the method. From the installation dream, to the final modified data table prefix!

Operation Step One:

Local tests (Figure 1)

Figure II:

  

Verify that the Dede_ data prefix is installed, as shown in the figure:

Figure 3

  

Figure 4

  

So next we start to modify the data table prefix. Before modifying, we back up the data, the backup process is: the website background------system------Database backup/restore-------and then submit. The default saved data is in the Data/backupdata directory.

The figure is the Dede_ table prefix.

Figure 5:

  

Then modify the directory under the Data/backupdata directory of all TXT file table prefix, dede_ Modify the table you need to prefix. As I was modified to abcd_ the table prefix.

Figure 6

  

As shown in Figure 6, the Dede_ table prefix has been changed to Abcd_.

Operation Step Two:

Immediately, open all txt files in the Data/backupdata directory, as shown in Figure 7:

Figure 7

  

Replace the Dede_ table prefix in Figure 7 with the Abcd_, as shown in Figure 8

Figure 8

  

Remember: The dede_ in all txt files in the Data/backupdata directory must be replaced with Abcd_. Then one search is really a little physical work. Here you can use the text to replace the expert. Finally modify the data directory under the common.inc.php file, find $cfg _dbprefix = ' Dede_ '; Modify the Dede_ to Abcd_. As shown in Figure 9

Figure 9

  

Operation Step Three:

Then we check the correctness of the operation, first of all, we will upload the data to (Data/backupdata) remember to remember to back up their own data and save, to avoid not only because of the operation of the data can not be restored!

We start to restore data--------database backup/restore--------data restore--------through the background--------system. Waiting for the data dedecms hint! " The data for all files was restored successfully! "That's it!" then let's see if we can access the site properly. As shown in Figure 10

Figure 10

  

Finally, let's check to see if the data is properly backed up. As shown in Figure 11

Figure 11

  

All normal, to modify the original data table prefix is successful.

Notes:

In addition, we will find a number of other data tables, do not worry, this is the data we used before, we just need to delete. As shown in Figure 12

Figure 12

  

Finally remind: avoid the first operation unfamiliar, there may be a variety of possibilities, suggest: the data back to the local test, until they fully operate correctly, in the space to operate. Remember!!!

I have operated no less than 10 times, are normal and correct. This article by (http://www.tea5998.com) original, welcome everyone reprint, reprint, please keep this link!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.