Import the entire PornHub via PornHub csv dump

Today we’ve made a few tests with the Pornhub’s webmasters csv dump.

We’ve split the 4gb dump file in a few smaller files and converted them to PHPVibe’s table vibe_video’s csv import options.
We’ve created a repo on Github for everybody to download and use the csv dumps.
You can import any dump via phpmyadmin directly to your database into the vibe_videos table.
Note: We’ve called them .cvs instead of .csv so they can’t be browsed easily 🙂 you could rename them, but this extension won’t affect your imports.

This isn’t a product. It’s just the result of some test we’ve run, that you may benefit from!

You’ll need Spicy for the Pornhub videos to work in PHPVibe.

Warning:

– Make a backup

– Know what you are doing

Importing so many videos to your database may slow down PHPVibe and your server.

– Optimize the database tables

– Sort your input

You can alter the videos from phpmyadmin directly, querying them by the fields date and also source.
Example:
Delete videos with views < 50k

delete from vibe_videos where views < 50000 and source like '%pornhub%' and date like '%27-07-2017%'

Reset all pornhub videos views to 0

update vibe_videos set views = '0' where source like '%pornhub%' and date like '%27-07-2017%'

Change the date to your import date 🙂

Sample importing