my Media -->Library content disappeared from the dashboard, but I still can see it inside my actual site folder.
Could anyone instruct me how to fix it?
|show 4 more comments|
Strangely enough , yesterday , while commenting to you , a similar thing happened to me on localhost . After a short investigation, I found out that one of my DB tables (wp_posts) was damaged (first time in 6 years of WP´ing ) .
The symptoms were :
AS the symptoms might differ from yours , and so does the recovery , It still
So, in order to fix this , you can do one of three things :
1 - Reinstall your website completely including DB
That depends on how much content you have on the website and on how much time you want to invest in total recovery.
you will essentially need to Copy and paste , upload all images , create new categories and posts . No import is suggested since we are talking about DAMAGED tables where the information relations themselves are damaged .
2 - Trying to RESTORE the damaged table .
GO into your PhpMyadmin, and goto YourDB-->structure
then flag your tables (maybe one by one ) and choose
3 - Try to handle the visible symptom of lost attachments only while ignoring other possible yet-to-be-discovered problems :
While it would be the less recommended for me , it might be the first try for someone with a lot of content and little time .
In that case, I believe your easiest option would be to try to reload all the images . But there is a catch.
If you will upload them AGAIN to the same uploads folder wordpress will try to avoid conflict naming and will rename them with sequential numbers ( eg.
So you need to BACKUP you uploads folder to another location, and then DELETE all the images from the wp-content/uploads folder . At this point , you need to UPLOAD them again from the backup folder , and attach. (thus maintaining the same names )
You could :
Note that in order to maintain the same names , you will have to upload only the ORIGINAL sizes and not the custom sizes (meaning
Making a long story short , There is no easy solution as far as I can see for such a problem , but to prevent it in the future ,
WILD GUESS EDIT Also , in the comments you said that you have deleted a user and then "restored" posts from the DB . This can be also the root of the problem, although hard to confirm.
In this case what you will need to do is something like this :
But next time, when you delete a user, make sure that you assign all the posts to another user before deleting it .
OK so you dropped the
You can see it yourself, open phpMyAdmin or any other MySQLClient and browse the