The phpwind 3.01 forum can be said to be one of the more powerful and faster among free forums. In the process of using this forum, I have accumulated some experience and share it with you:
1. Data backup
As the amount of forum data continues to increase, it often happens that one file cannot accommodate all the backup data according to the default file size. If the host speed is relatively slow and the network speed is not good, a white screen will often appear and no response will appear after the first file is generated. Never think that the backup is complete (we have been fooled by this and suffered heavy losses!).
When this happens, it's best to use a browser that responds quickly. I use Opera, which can generally reflect the backup process normally. You must wait until the prompt that the backup is complete appears to indicate that the backup is truly completed.
Another possible way is to modify the size of the backup file. For example, if your backup file is about 1MB, set it to 2048K. This will prevent the backup from aborting halfway.
2. Use the recovery function of phpwind to execute SQL statements
The backup file of Phpwind is actually the SQL statement of the database, which is divided into two categories: statements to delete and rebuild tables and statements to insert data. If the backup data of your database is incomplete, you can manually add SQL statements to the backup file (you can also delete some statements, such as deleting the statements for table structure reconstruction, and only keeping the statements for inserting data). Just keep the header of the backup file content. Just a few complete lines are enough. And you can use any SQL statement, phpwind will faithfully execute these SQL statements for you.
3. Tips for space migration without reinstalling phpwind:
Migrating space can be said to be something that we often encounter (no way, who said that our virtual hosting service providers in China are mixed, and we often encounter bad people?) According to the conventional method, you need to re-upload the installation file and re- Install phpwind, then overwrite the installation directory with your modified BBS directory, and finally restore the MySQL database. This requires a rather lengthy FTP upload process, especially when the internet speed is average.
In fact, today's virtual hosting service providers generally provide the phpMyAdmin database management tool. Using this tool, you can skip the installation process:
Disclaimer: If your virtual host cannot provide phpMyAdmin, and you have not installed phpMyAdmin yet, then there is no need to read the following (because the time required to upload and install phpMyAdmin is no less than phpwind, I have been fooled once )
- If your backup file is small (a few hundred K) and the Internet speed is good, you can directly execute the backup file in phpMyAdmin by executing the SQL file.
However, if the file is too large, according to my tests, even if it is only about 1MB, it is often difficult to succeed if the network speed is average. Therefore, it is still essential to install an original version of phpwind.
However, if you are interested, you can modify the backup file, extract only the data structure part of it, and then execute it.
In other words, you can actually find a clean database file of a newly installed phpwind (so, it is best to save the first backup of your website), and first use PhpMyAdmin to execute this file to restore the database structure.
- The next step is to copy the forum directory you backed up to the new space (you need to keep the sql_config.php file under the data directory), and restore your BBS web page file. If your BBS file has not been modified in any way, Then just use the installed files directly. Otherwise, you still have to upload your BBS file that has been modified many times.
- In addition, if you are using a UNIX-type host, you also need to modify the attributes of some directories. You can follow the requirements of the phpwind installation instructions and change the attributes of several directories to 777 (in fact, changing it to 755 can often run normally) , the new forum is basically migrated successfully.
It is worth noting that don’t forget to modify the attributes of several files under the simple directory to 755, otherwise the interface without graphics cannot be accessed correctly (this is what I accidentally discovered when checking the access source of the site. We never The imageless version used is the favorite of search engines).
- 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 phpwind, then copy the sql_config.php file under the data directory in the phpwind directory you just installed to the data directory of your real forum directory, and set the file attribute to 777.
- Finally, the key step is to use FTP to upload your real database backup file to the Data directory, and then log in to the backend with the phpwind administrator account to quickly restore your data.
After restoring the data, finally update all caches in the background.