1. My WordPress website could not be opened. At that time, I could not use the WordPress plug-in to back up the data into sql format, so I had to back up the mysql folder and theme plug-in.
2. After reinstalling WordPress, I created a database with the same name as before, table prefix, account number, and password, and then replaced the new website name folder with the backed up website name database folder in the mysql folder. As a result, the website cannot be accessed,,,
3. After searching online for a long time, someone said that I should copy the ibdata1 file into it, and then I used the backup ibdata1 file to replace the newly generated ibdata1, but to no avail.
4, add
innodb_force_recovery= 4 under [mysqld] in /etc/my.cnf and restart to no avail.
5, I deleted several ib_log* files and restarted mysql but it still didn’t work.
6. Now that the website is open, reinstall WordPress. In the last step of installation, User(s) already exists. The user already exists,,,
7. Now the database can be connected and the tables inside can be checked, but the website cannot be accessed. Please help me!
After struggling all night, I tried clearing the cache and changing files, but nothing worked. Please give me some advice. If there is a master who can help online, I will definitely send a red envelope to thank you! ! ! Thank you Q2981356385!
P粉7929682602023-03-24 18:03:09
Is the original poster here? Add me and I will build a website with you
阿神2017-07-07 10:37:20
Use a tool to export the database into a file, then delete the database, reinstall WordPress, and finally import the database file into it
