# What are those variables in dump.sql

**URL:** <https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896>\
**Category:** Support\
**Created:** [May 19, 2018, 7:11pm UTC](https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896 "2018-05-19T19:11:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![uptownyumiko](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/uptownyumiko/32/119808_2.png) [@uptownyumiko](https://meta.discourse.org/u/uptownyumiko)\
**Post date:** [May 19, 2018, 7:11pm UTC](https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896/1 "2018-05-19T19:11:43Z")

</div>

Hi,

I am trying to figure out information such as the people who posted the most, the people who responded the most, the pairs who interacted the most. I have downloaded dump.sql file but not sure what each variable represents. Is there any place I can find the reference?

Thanks!

---

<div class="post-metadata">

**Author:** ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)\
**Post date:** [May 19, 2018, 8:45pm UTC](https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896/2 "2018-05-19T20:45:10Z")

</div>

You can use the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin’s most common likers query to identify which are which.

---

<div class="post-metadata">

**Author:** ![uptownyumiko](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/uptownyumiko/32/119808_2.png) [@uptownyumiko](https://meta.discourse.org/u/uptownyumiko)\
**Post date:** [May 20, 2018, 4:20pm UTC](https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896/3 "2018-05-20T16:20:01Z")

</div>

oh this seems to be what I am looking for. thanks!!! Will try that!

---

<div class="post-metadata">

**Author:** ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)\
**Post date:** [November 6, 2020, 12:32pm UTC](https://meta.discourse.org/t/what-are-those-variables-in-dump-sql/87896/4 "2020-11-06T12:32:11Z")

</div>


