1
$\begingroup$

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.

By the agency of 127.0.9.6's answer, I question if you can download all your questions, answers, and comments in one query? I see 2 now.

http://data.stackexchange.com/math/query/38557/get-all-your-posts-and-comments is for your questions and comments.

http://data.stackexchange.com/math/query/172383/all-answers-by-a-user-with-questions is for your answers.

$\endgroup$
7
$\begingroup$

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).

However, downloading answers without matching questions is probably not very useful. Here is a query to get your answers with the questions to which they refer.

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.

$\endgroup$
  • $\begingroup$ thanks. +upvote. i want to check if you can download all your questions, answers, and comments in one query? Please apprise me in your answer? $\endgroup$ – Analysis JD Mar 3 '14 at 16:06
  • $\begingroup$ 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.) $\endgroup$ – Martin Sleziak Mar 3 '14 at 18:15
  • $\begingroup$ I found it: It was mentioned here that there is a limit of of 50000 results for one query. $\endgroup$ – Martin Sleziak Mar 3 '14 at 18:21
  • 1
    $\begingroup$ @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. $\endgroup$ – user127096 Mar 3 '14 at 18:21
  • $\begingroup$ Even Jon Skeet of Stack Overflow fame has <30000 answers so far; though he does have >50000 comments. $\endgroup$ – user127096 Mar 3 '14 at 18:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .