discuz! X database transcoding scheme and usage tools

convertdb.php

Placed in the Discuz X series root directory.

1. The configuration information in this file will be read config_global.php.

2, will be the configuration information in the entire database of the tables are converted, if there are multiple applications in a library, you need to be careful to avoid the other tables also go.

3. Use the ALTER TABLE table_name convert to CHARACTER SET charset command to convert.

4, the database is too large possible transcoding process takes a long time, PHP will time out, it is recommended to use the command line to Transcode.

serialize.php Serialization Grooming Tool

In the Web application root directory, which is used after the database is transcoded. At present, the UCHOME2.0 discuz! were made. X2 discuz! X2.5 is compatible with the processing.

Transcoding steps:

1. backing up the database

2, using convertdb.php for database transcoding, this step if you have permission, you can use the command line version of the tool.

3, transcoding after the corresponding version of the program to overwrite the existing program.

4. Change the encoding in the config file (e.g. original $_config[' db ' [' 1 '] [' dbcharset '] = ' GBK ' to $_config[' db ' [' 1 '] [' dbcharset '] = ' UTF8 ')

Note the above, in discuz! X in the configuration file to change the database encoding and output encoding, the output encoding utf8 written as ' utf-8 '

5. Use the serialization finishing tool to organize the serialized fields in the database.

Program Download Https://github.com/rikioy/DiscuzTools/tree/master/DiscuzTranscode

The original was in http://www.discuz.net/thread-3443658-1-1.html,

discuz! X database transcoding scheme and usage tools