2
$\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$
1

1 Answer 1

Reset to default
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$
5
  • $\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$
    – user53259
    Commented Mar 3, 2014 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
    Commented Mar 3, 2014 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
    Commented Mar 3, 2014 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
    Commented Mar 3, 2014 at 18:21
  • $\begingroup$ Even Jon Skeet of Stack Overflow fame has <30000 answers so far; though he does have >50000 comments. $\endgroup$
    – user127096
    Commented Mar 3, 2014 at 18:27

You must log in to answer this question.