HexionMC Full Forum Database Dump

[Aeroski]

Doesn't contain passwords. Exported useful data. Basically parsed so it only contains user table. 

I was wondering about this yesterday. I am very interested in knowing how you did this, so quickly too. From that .sql file of random information, how did you sort it to just username:email:gender? 
Would appreciate if anyone could help out with this.

way i do this is i import the sql file into myphpadmin localhost xamp server then i open myphp admin i select which columns i want to export and in which format and it just exports as simple as that. I'm not sure if he has a different tool or method!

I just thought about trying Excel, seems to work. Thanks for your explanation though

[iDontSpam123]

It's pretty easy. Google it

---

mysql -u root -p -e "create database hexion"
mysql -u root -p hexion < hexion.sql
mysql -u root
USE hexion
SHOW TABLES;
SHOW columns from table XTABLEHEREX
SELECT CONCAT_WS(':',column1,column2,column2) FROM XTABLEHEREX

[goon]

Thanks for this minecraft right/

[Aeroski]

Thanks for this minecraft right/

Yea its a dump from a MC server forum

[redbull*]

HexionMC.com? The website's offline right now.

[Aeroski]

HexionMC.com? The website's offline right now.

Not sure, someone else said that too. I don't personally play it but it was a forum of some MC server. But they apparently combined with another server, and one of the leaders or admins didn't like that so he leaked the database.