Forum set up with tips Phpwind configuration tips Three

Phpwind 3.01 Forum can be said in the free forum inside, is more powerful, and the speed of a better one. In the process of using this forum, we have accumulated some experience and shared with you:

1. Data backup

As the amount of data in the forum grows, it often happens that a file is backed up in the default file size, and that one cannot hold all of the backup data. If the host speed is slow, and the network speed is not good, this is often prompted the first file after the emergence of white screen, loss of response. Do not think that the backup has been completed (we have been this time, the loss of heavy!) ）。

In this case, it is better to use a faster response browser, I am using opera, generally can normally reflect the backup process. Be sure to wait until the backup is complete to show that the backup is really complete.

Another option is to modify the size of the backup file, for example, if your backup file is about 1MB, set it to 2048K, which prevents the backup from being half-aborted.

2. Execute SQL statement using Phpwind recovery function

The backup file of Phpwind is actually the SQL statement of the database, which is divided into two categories: the statement to delete the rebuilt table and the Insert data statement. If your database has incomplete backup data, you can manually add SQL statements to the backup file (you can also delete some of the statements, such as delete the table structure reconstruction statements, only the statements inserted data), as long as the backup file contents of the header a few lines intact. And you can use arbitrary SQL statements, and Phpwind will faithfully execute these SQL statements for you.

3, do not reinstall Phpwind, the secret of space migration:

Migration space can be said to be often encountered things (no way, who call us China's virtual hosting service providers, and we often meet people sparked it? As a general rule, it is necessary to re-upload the installation files, reinstall Phpwind, and then use your modified BBS directory to overwrite the installation directory, and finally restore the MySQL database. This requires a fairly lengthy FTP upload process, especially when the Internet is in general.

In fact, today's virtual hosting providers generally provide phpMyAdmin database management tools, using this tool, you can skip the installation process this step:

Disclaimer: If your virtual host does not provide phpMyAdmin, and you have not installed phpMyAdmin, then the following do not have to look at (because the time required to upload and install phpMyAdmin is no less than phpwind, I have been a big when)

-If your backup file is very small (hundreds of k), and good speed, you can in phpMyAdmin, directly with the implementation of the SQL file method, execute the backup file.

However, if the file is too large, according to my test, even if only about 1MB, if the speed of the general, it is often difficult to succeed. So installing an original version of Phpwind is still essential.

However, in fact, if you are interested, you can modify that backup file, extract only the part of the data structure, and then execute it.

In other words, you can actually find a clean database file of the newly installed phpwind (so it's best to save your site's first backup), and then use phpMyAdmin to execute the file to restore the database structure.

-The next job is to copy your backup of the forum directory into the new space (need to keep the data directory under the sql_config.php file), restore your BBS web file, if your BBS file has not been modified, then directly with the installation of files on it. Otherwise, you will upload your BBS files that have been modified many times.

-In addition, if you are using a Unix-type host, you also need to modify the properties of some directories, you can follow the requirements of Phpwind installation instructions, the properties of several directories to change to 777 (in fact, changed to 755 also often can run normally), the new forum even the basic migration success.

It is worth noting that, do not forget to modify the simple directory under the properties of several files are 755, otherwise no plate interface is not properly accessed (this is I in the view of the site of the source of access inadvertently discovered, we never use the No chart is the search engine favorite AH).

-Next, don't forget to modify the database name, user name, password and other information in the sql_config.php file under the data directory.

If you are reinstalling the Phpwind, copy the sql_config.php file under the data directory from the Phpwind directory you just installed to the data directory of your real forum directory and set the file properties to 777.

-Finally, the key step is to upload your real database backup files with FTP to the data directory, and then log in with the Phpwind administrator account to quickly recover your data.

After the data is restored, all caches are updated in the background at the end.

