Ashley Madison part 1: Getting the database

I downloaded the Ashley Madison database dump.

The dump was available here I downloaded it in an Ubuntu VM for safety precautions.

The files available:


The file member_login.dump is a MySQL database backup. First I installed the database with:

$ sudo apt-get install mysql-server

Start MySQL with

$ mysql -u root -p

Now we need to create a new database and restore from the backup. We’ll go ahead and import member_login.dump and member_details.dump:

$ mysql

> create database AshMad

> use AshMad

$ mysql -u root -p < Downloads/dmps/member_login.dump

$ mysql -u root -p < Downloads/dumps/member_details.dump

And now MySQL will import the database.
Note: Do not use the MySQL source command to import large databases. Source is designed to run a small number of SQL queries, and will take a long time to import a large database.

Let’s explore the imported tables.

mysql> use AshMad;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
| Tables_in_AshMad |
| member_login     |
| member_details   |
2 rows in set (0.00 sec)

mysql> show columns from member_login;
| Field    | Type         | Null | Key | Default | Extra          |
| pnum     | int(11)      | NO   | PRI | NULL    | auto_increment |
| username | varchar(28)  | NO   | UNI |         |                |
| password | varchar(128) | NO   |     |         |                |
| loginkey | varchar(36)  | NO   | MUL |         |                |
| notify   | int(4)       | NO   |     | 0       |                |
5 rows in set (0.00 sec)

Now we’re going to dump the password column into a text file for a password cracker. This might take a few minutes, as there are almost 4 million rows.

> select password from member_login into outfile 'ashmadpasswords.txt' lines terminated by '\n';

Now we have the passwords in a .txt document in the file /var/lib/mysql/AshMad/ashmadpasswords.txt;

Lets check the file to see what we have:

$ head -10 /var/lib/mysql/AshMad/ashmadpasswords.txt 

And that’s it for part 1.

  1. Hi,

    Just dropping in a quick line to know, May I send some great article ideas your way for a guest post at your website? If you like my suggested ideas, I can then provide you with high-quality FREE CONTENT/ARTICLE.

    NOTE: In return for the FREE CONTENT/ARTICLE that I will be providing you, I would expect just a favor of a backlink from within the main body of the article.

    Kindly let me know if I can interest you with some great topic ideas?

    Have a great day!

    Abi Cool

    – This is an ad.
    – Address: ST 18, Awan Town, Rawalpindi
    – Unsubscribe:

  2. BEST PRIVATE PROXIES – Elite quality, Endless bandwidth, 1000 mb/s superspeed, 99,9 uptime, Non sequential IP’s, No utilization restrictions, Numerous subnets, USA or Europe proxies – Buy Now –

  3. I believe that is one of the so much vital information for me. And i’m happy reading your article. However wanna observation on some basic issues, The site taste is wonderful, the articles is in point of fact great : D. Good task, cheers

  4. Howdy this is kind of of off topic but I was wanting to know
    if blogs use WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding expertise
    so I wanted to get guidance from someone with experience.
    Any help would be enormously appreciated!

  5. Pretty good article. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way Ill be coming back and I hope you post again soon.

  6. What’s Taking place i am new to this, I stumbled upon this I’ve found It positively useful and it has aided me out loads.

    I am hoping to contribute & help different users like its helped me.
    Good job.
    erectile dysfunction pills

  7. I’m not sure why but this website is loading very slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later and see if the problem still exists.