Partial data migration for new ver.PHPMyFAQ
Posted: Thu Apr 25, 2024 7:23 am
Hello.
I have a problem with phpMyFAQ after upgrade.
I have done an incremental upgrade of phpMyFAQ, PHP and MySQL which is very unstable and has not solved the problem.
[Infrastructure.]
Azure Web App / nginx 1.24.0
[old configuration] *worked stably
MySQL 5.7
PHP 8.1
phpMyFAQ 3.1.16
[New configuration]
MySQL 8.0
PHP 8.2
phpMyFAQ 3.2.0
[Example problem]
- Failed to restore backup file with "404 Not Found" error -> Unable to log in to FAQ
- "404 Not Found" error occurs when modifying FAQ.
- There may be other unconfirmed problems.
On the other hand, I have also confirmed that a clean install of phpMyFAQ with the new configuration works stably.
I would like to try to clear this problem by importing the backup data of the old configuration into a clean MySQL 8.0/PHP 8.2/phpMyFAQ 3.2.0 environment.
Is this possible? Also, are there any specific steps to follow?
I currently have the following resources
- MySQL 5.7 -> 8.0 dump file immediately after upgrade
- Backup of all phpmyFAQ 3.1.6 files (under faq/)
- Dump file immediately after upgrade to phpFyFAQ 3.2.0
At a minimum, I would like to import the following information into a clean environment
Appearance is not important.
- User account information
- FAQ categories
- FAQ posts (questions/answers/embedded images/attachments)
I hope someone can provide a good solution.
Thank you in advance.
I have a problem with phpMyFAQ after upgrade.
I have done an incremental upgrade of phpMyFAQ, PHP and MySQL which is very unstable and has not solved the problem.
[Infrastructure.]
Azure Web App / nginx 1.24.0
[old configuration] *worked stably
MySQL 5.7
PHP 8.1
phpMyFAQ 3.1.16
[New configuration]
MySQL 8.0
PHP 8.2
phpMyFAQ 3.2.0
[Example problem]
- Failed to restore backup file with "404 Not Found" error -> Unable to log in to FAQ
- "404 Not Found" error occurs when modifying FAQ.
- There may be other unconfirmed problems.
On the other hand, I have also confirmed that a clean install of phpMyFAQ with the new configuration works stably.
I would like to try to clear this problem by importing the backup data of the old configuration into a clean MySQL 8.0/PHP 8.2/phpMyFAQ 3.2.0 environment.
Is this possible? Also, are there any specific steps to follow?
I currently have the following resources
- MySQL 5.7 -> 8.0 dump file immediately after upgrade
- Backup of all phpmyFAQ 3.1.6 files (under faq/)
- Dump file immediately after upgrade to phpFyFAQ 3.2.0
At a minimum, I would like to import the following information into a clean environment
Appearance is not important.
- User account information
- FAQ categories
- FAQ posts (questions/answers/embedded images/attachments)
I hope someone can provide a good solution.
Thank you in advance.