QgBack database backup system v1.0
Development environment: windows 2003 + php4.4.4 + mysql3.23.58
This program theoretically supports unlimited database information backup!
Currently, Discuz5 has been tested and has no error in backing up data when the data volume is >90M!
Attached note: This program has not been tested in PHP5 and MYSQL5 environments, and we cannot guarantee whether it can be supported! (Currently we can only guarantee that the data will not be affected during recovery!)
Note when running the program:
· You need to have permission to create the folder, and this permission must have write permission! If you are not sure whether your space supports it, please manually create a folder with the same name as your database!
· In order to ensure the safety of your program operation, please change the administrator's account and password in time! (Modify file: index.php)
· To ensure the success of the program, you need to set the root directory URL!
If your website: http://www.example.com
And if you put the program in the system_bak folder, then you need to set the variable $url information to:
http://www.example.com/system_bak/
Let me emphasize here again that even if you set the root directory, it should be set to:
http://www.example.com/
The program can recognize it normally!
——————Don’t you think it’s very wordy! There's no way, too many people don't follow the instructions and end up with problems! I can only do it for a moment!
Program installation:
1. Upload the file: index.php to the corresponding directory (for security reasons, it is recommended that you manually create a directory on your website!)
2. Set initial variable information
3. Regarding the setting of $lang, if your database version is higher than 4.1! It is recommended that you set it to gbk. If it is lower than 4.1, haha, it doesn’t matter~
Backup instructions:
1. After verifying the username and password, set the information for the database you want to back up! You can back up normally!
Recovery instructions:
1. Before restoring the database function, you need to ensure that the database you want to restore exists. The system will not create it by itself!
2. Make sure that the name of the folder is the same as the name of the database. At the same time, make sure that the file [database name.sql] exists, where the data table structure information is stored! If the file information is not saved, this program cannot be used!
3. That is to say, if you want to move, for example, when moving database: A to database: B, you need to do the following actions:
(1) Back up database A information
(2) Modify the backup folder name A->B
(3) Modify the backup file A.sql->B.sql
(4) Restore database B information