search

isohuntto / openbay-db-dump

GNU General Public License v3.0
110 stars 39 forks source link

[TORRENT] The database as SQL dump #5

Open nexusrain opened 9 years ago

nexusrain commented 9 years ago

So, guys. Fuck dat shit, here you go:

http://torcache.net/torrent/30A7A1B67117218BE82977F9F5A9C91EAA7DA40F.torrent

The DB as SQL dump. You can easily import it into MySQL.

Pls seed nicely, I've already multiple servers running which are seeding @ full speed...

To unpack: apt-get install p7zip-full 7z e torrents_mini.sql.7z

And there is your .sql

aaruni96 commented 9 years ago

screenshot from 2014-12-27 00 50 34

nexusrain commented 9 years ago

deluge utorrent

Pls give it a bit... Seeding servers are in NL & US right now...

aaruni96 commented 9 years ago

I'll let it run overnight, I guess.

nexusrain commented 9 years ago

Looks like some trackers are down (obt & ccc). I think I'll upload a new torrent only with publicbt due it seems like its online and working...

nexusrain commented 9 years ago

bittorrent

Works good for me now.. Same torrent link.

nexusrain commented 9 years ago

Alright, its obviously working now cauz thats not me :p bt

matheusgimenez commented 9 years ago

Please upload this file in a HTTP server (mega.co.nz, or whatever). Download is slow.. very slow :(

nexusrain commented 9 years ago

@matheusgimenez Yea cauz obviously I'm the only one which is seeding.. And in the meantime I'm seeding with 3 servers (NL, US, RO). However, it may be easier. Will post when I'm done..

nexusrain commented 9 years ago

Well guys. Thats quite embrassing. My SQL dump MUST be valid due there was not a single error while importing the csv, not a single error while dumping it and the dump seems quite good (and the size with uncompressed 1,2GB too I think). But OpenBay is FUCKING still importing the included schema file. And you know the best? Its even OVERWRITING the table with the data from the csv. I'll try something tomorrow: raising the max script execution time and so on, and then I'll put MY dump in protected/data Then it cannot overwrite it with the included schema file, huh. Maybe someone else got an idea, but my SQL dump nearly MUST be valid...

EDIT: Already got an idea. AFTER the setup of OB, I'll import my dump into the table OB uses. Then its also nearly forced to use it, isnt it..

EDIT 2: And here's your OCH link: https://mega.co.nz/#!0c521Z4A!d40kLykFhay5xhcxp59CWN8fdnajgnlNT06mbqM9S8c ...

TheChiefCoC commented 9 years ago

i was able to move the sql in the database. But all the torrent names have " (inverted commas) in the names . how to fix that?

nexusrain commented 9 years ago

@TheChiefCoC Thats normal. MySQL can work with curved '' as well as with "normal" ones.

TheChiefCoC commented 9 years ago

@nexusrain ok. If thats normal then good. I finally got it all working. Will post the tutorial on openbay github.