Matching Story ID To Text File
A user mistakenly deleted her fic. She is looking for a specific story stored in the backup I have of her userid folder. the problem: the story is multi chaptered and the storyid we had does not match up to any of the txt files.
Ex: Author User ID folder
Story ID: 5575 (for the first chapter. we don't have the IDs for the next ones)
All the text files in her folder are 16792
There are over 100 text files in the folder and many have no titles in the body of the text.
Do you have a backup of the MySQL database as well? The text files are given the name of the Chapter ID (chapid) in the _chapters table, and not the story.
Generally those text files should only contain the chapter itself, as the title of the chapter (as well as the description and stats) are saved in the database.
I had the same issue for an author who deleted a hundred plus chapter story. She had hundreds of chapters. I ended up uploading my database backup to my test server and running a query to pull all chapter IDs for that story.
I was able to restore it to the site and I did post about it so you could include my username in a search here of you want to find it.
Thank you. I'll let the author know.