TheTVDB.com

Online TV Database
It is currently Sun May 19, 2013 6:31 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 23 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: Latest Export
PostPosted: Fri Sep 09, 2011 10:55 pm 
Offline
Site Admin

Joined: Fri Nov 03, 2006 5:23 pm
Posts: 2145
Coco wrote:
Here's a current DB dump. This is actually a 7z file but due to a limit with this host I had to rename it to rar.
February 4, 2013 1:00am MST 199MiB


---OLD----
October 3, 2012 1:00am MST 197MiB
June 16, 2012 198MiB
Sept 9, 2011 157MiB
Sept 28, 2010 125MiB
May 1, 2010 112MiB

The latest database export is here, thanks to Coco.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Wed Nov 23, 2011 5:00 pm 
Offline

Joined: Fri May 13, 2011 12:56 pm
Posts: 1
Hi, is this file ok? rar complaints that it's not a rar file. any ideas?


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Thu Nov 24, 2011 2:25 am 
Offline
Site Admin

Joined: Tue Mar 13, 2007 10:16 pm
Posts: 1902
Location: Canada
It might actually be a 7z file. I don't really remember, either way it shouldn't matter as winrar can open a 7z file.

_________________
Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't answer you.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Sat Nov 26, 2011 11:22 pm 
Offline
Site Admin

Joined: Fri Nov 03, 2006 5:23 pm
Posts: 2145
http://www.7-zip.org/


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Wed Jan 11, 2012 5:15 am 
Offline

Joined: Tue Jan 10, 2012 5:06 pm
Posts: 9
Any chance of a new dump or a re upload as i just downloaded that file and 7zip can not open it no matter the file extension so i think it may have been damaged either before or during upload.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Wed Jan 11, 2012 11:27 am 
Offline
Site Moderator

Joined: Sat Oct 16, 2010 5:48 pm
Posts: 1093
Location: England
seer_tenedos wrote:
Any chance of a new dump or a re upload as i just downloaded that file and 7zip can not open it no matter the file extension so i think it may have been damaged either before or during upload.

Looks fine to me, just downloaded it and used 7-zip 9.22 (beta) to extract it, and then loaded it (taking quite a while) in notepad, all on windows 7 and could see all the sql. Incase it's any use I've just run a randomly found md5 checksum tool against my download to get the checksum 21E73065744EDE531EDE45200C1D4879

_________________
---

Please watch this video to help LSU Computer Society try to win the RBS ESSA society competition! http://youtu.be/8JrhmoSXLXw - only 1:36min

Thanks :D


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Wed Jan 11, 2012 2:39 pm 
Offline

Joined: Tue Jan 10, 2012 5:06 pm
Posts: 9
etw wrote:
Looks fine to me, just downloaded it and used 7-zip 9.22 (beta) to extract it, and then loaded it (taking quite a while) in notepad, all on windows 7 and could see all the sql. Incase it's any use I've just run a randomly found md5 checksum tool against my download to get the checksum 21E73065744EDE531EDE45200C1D4879


Thanks you are right it seems to be my download. i downloaded again and it was fine.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Sun Jun 17, 2012 12:22 pm 
Offline
Site Admin

Joined: Tue Mar 13, 2007 10:16 pm
Posts: 1902
Location: Canada
Here's a current DB dump. This is actually a 7z file but due to a limit with this host I had to rename it to rar.
June 16, 2012

_________________
Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't answer you.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Wed Oct 03, 2012 4:38 pm 
Offline
Site Admin

Joined: Tue Mar 13, 2007 10:16 pm
Posts: 1902
Location: Canada
October 3, 2012 1:00pm MST 197MiB

_________________
Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't answer you.


Top
 Profile  
 
 Post subject: Re: Latest Export
PostPosted: Sun Oct 07, 2012 10:21 am 
Offline

Joined: Fri May 13, 2011 6:34 am
Posts: 68
thanks for DB dump! how i can retrieve a list of all tv series? i see that there is 6 schemas:
information_scehma
mysql
perfomance_schema
sakila
test
world

i want know what schema i have to use to retrieve a list of all tv series name?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 23 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group