I have a client that wanted to move a category in their site. They drag/dropped it, the system said it would take a while, then everything just disappeared. The values are gone from the database as well. Any ideas? This seems very strange that the values would be removed from the DB.
when you move/drag any category then it also re-arranges all URLs and that takes a lot of time
& this seems like the transaction timeout occurred.
please check the value for path in database table catalog_category_entity
for your category id.
but if this messed up then you need to restore from the latest database backup.