Joy
(@joyously)
Did you copy the mySQL data files or did you export the tables?
Depending on the query engine used, moving the files can make them unusable since the index is messed up. But exported tables can be imported easily.
You can install WordPress on your computer to handle that,
Installing WordPress on your own Computer
or try a sandbox like http://poopy.life/
Use a plugin like https://ww.wp.xz.cn/plugins/wp-phpmyadmin-extension/ to access the database directly to import the posts table, which is where the content is. (it also has attachments and menu items and revisions) If you need the tags and categories, you’ll need to do those tables also. Don’t do the options table since it will mess up your installation. The user table might conflict with whatever new installation you are using, but if you need it for authors, you could carefully add those manually.
Try creating a new WordPress installation and if possible, add and activate the theme you had when the site crashed. If you had a page builder activated, add it too. Next, use PHPMyAdmin and import the data of the old database to the current (new) one. You may get a message like “WordPress Needs To Configure The Database”, let it finish and visit the website. If you’re lucky, the posts and pages should be there.
If it doesn’t work, try with previous versions of WordPress and the theme. If you can estimate the time when the incident happened, you can even find the exact version. Check here https://ww.wp.xz.cn/download/releases/
