Why can't I run data queries on the Math Site?, How do I know I won't lose all my work in math.SE? say there are data dumps for math.se. But how do I download only the data for one user? This data includes all the text as people typed, right? Ergo I will have the $mathjax$?

I don't want to download the data dump for the whole website. I want to backup and save all questions and answers for users for offline use. I'm not fantastic with computer programming.

• – Tim Seguine Mar 3 '14 at 15:24

One of several queries that could be used for this purpose is Get all your posts and comments. The last column indicates the type of post: 1 = question, 2 = answer, 3 = comment. For your convenience, here it the query with your UserId pre-filled. You do not need to create a Data Explorer account; queries can be run anonymously (you'll just get a CaptCha to solve).

Keep in mind that Data Explorer imports data from the site weekly (on weekends). So your very recent posts will not appear in the results.

• Isn't there a limit on maximal number of results returned by a SEDE query? (IIRC someone mentioned the existence of such limit on this meta. I searched a little on meta.SO, but did not find what the limit is. Although I do not know whether such number of answers and comments can be realistically written by one user.) – Martin Sleziak Mar 3 '14 at 18:15
• I found it: It was mentioned here that there is a limit of of 50000 results for one query. – Martin Sleziak Mar 3 '14 at 18:21
• @MartinSleziak Yes, a query returns at most 50000 rows. That ought to be enough for anybody™: e.g., Brian M. Scott posted <9000 answers and <15000 comments. Also, a query can be modified to return only posts within a given time interval; then one can run it several times and merge the results in a spreadsheet. One can download all posts in this way, if one wishes. – user127096 Mar 3 '14 at 18:21
• Even Jon Skeet of Stack Overflow fame has <30000 answers so far; though he does have >50000 comments. – user127096 Mar 3 '14 at 18:27