Thread: Setting up the in 2007 leaked PreDB

Setting up the in 2007 leaked PreDB

Torrentfreak wrote:

Usually, when a leak is made by the warez scene, it’s usually material created by someone else - a movie, music, games or software. This time the leak is of their own material. A huge pre database of 2.6 million entries has become available on the internet, containing information on warez scene releases dating back to 1980.

read more on Torrentfreak.com

At the end of this turorial you will have a searchable pre database as shown on this screenshot:

Required files:

PREDB: download
XAMPP: website | download ... it's important that you use v1.7.0 !
Bigdump: website | download



Step 1: Installing XAMPP wrote:

First we're going to set up a webserver ...

• Unpack XAMPP to your c:\ directory
• Run xampp-control.exe and start Apache and MySql

Step 2: Installing Bigdump wrote:

Since phpMyAdmin has trouble with opening large databases (and our db is 272MB unpacked) we need a script that splits it up in parts and automaticly feeds them to phpMyAdmin.

• Unpack the .php file in bigdump.zip to C:\xampplite\htdocs\xampp\

Step 3: Configuring Bigdump wrote:

• In the file bigdump.php edit the following parameters:

$db_name = 'test';
$filename = 'predb.sql';

Step 4: Using Bigdump wrote:

• Inside DATABASE.READNFO.tar.gz you will find a file called predb.sql.bz2, open this file and extract "predb.sql" to the same directory as the bigdump script [C:\xampplite\htdocs\xampp\].
• Visit this link to bring up the Bigdump script.
• Press "Start Import" to start feeding the database to phpMyAdmin.

Warning: do not close the page as long as it's still loading, this can take some time.

Step 5: Using phpMyAdmin wrote:

By now you have all the files in place and you can start managing the database in phpMyAdmin

• Now you can open phpMyAdmin here.
• In the treebar on the left press "test".

When pressing the first icon in the actions table behind "predb" you can browse the PREDB. From there you can use the search button to filter your database.

Tip:

• The pretimes are stored in unixtime format. You can convert this value to a regular date time format here: Online Conversion - Unix time conversion

this tutorial is from SCC - Link ...