Lo and behold! The bible database contains two full translations of the bible (King James and Basic English), as in both Old and New Testaments as well as the Apocrypha. Verses are on one row each, with cap/book/verse columns in the table to find your way around. And if that's not enough, I've now added three translations of the Koran (or Qur'an if you prefer) in a separate Koran database.
So if you want to get God into your database, and have MySQL 4.1 or higher, then get downloading.
| contents | gzip file | plain file |
|---|---|---|
| Bible | bible.mysql.gz 3 MB |
bible.mysql.txt 11 MB |
| Koran | koran.mysql.gz 937 K |
koran.mysql.txt 2.8 MB |
Once you've done that, you might wish to look at the Instructions to get it all working especially if you're new to MySQL. Otherwise get with the Holy SQL.
Comments
Dump error on koran
The Koran sql dump is missing the create database statement. I just added it back in myself, but if other complain that's the issue.
-- Thanks for pointing that out, it's now corrected. The koran sql dump will create the koran database if one doesn't already exist. - Ed
Other copyright free databases
This Bible data is perfect for making so called data base websites for search engines to crawl that are later used for search engine optimization prurposes. Anyone know where to find similar copyright free SQL dumps?
Good Work
I am using this and making automatic translations to 52 languages. Also as a geek project.
This is great! I've been
This is great! I've been looking for this, and I was worried that even if I found it, the format would be too weird. This is great, though. Thanks!
Hello
Great work man....awesome.Thanks for the article.
Thanks for the database
Thanks a lot for this.
GREAT PROJECT, WONDERFUL!
GREAT PROJECT, WONDERFUL!
Thanks
This is awesome!, i can really do a lot with this database, instead of using curl and some dodgy code to grab a verse off another website which takes forever. Cheers heaps.
This is fantastic
Praise God for this. you have done a great job. I have been playing around with the queries and having a little fun.
Thank you for taking the time to do this.
on a further note. this would be great as a step further to put in multiple translations so you can search like in Keyword for strongs, to vines dictionary, to interlinear to NIV, KJV, NLT, NKJV etc then execute the query.
God Bless you
Ain't it cool being a servant?
If you can point me towards any copyright free texts I'd be happy to take a look - Ed.
Num 6:24-27
Num 6:24-27
The Good thing about this
The good thing about this is it isn't copyrighted, cause it belongs to God, and He gives it to us free.
God bless.
Thanks
Thank you so much for this! You are great! Many blessings to you!
Where is the mysql?
I was looking for something like this and am interested in receiving the database. But where is the actual mysql data tables?
---- Download the files at the top of the page, or see the download section - Ed.------
Not working
I am trying to lad the sql into mysql client. it keeps freezing and nver loads cos of the size.
When copy it section by section i get errors. So wanted to ask how do you create the database.
do u do it with a special client??
-- I just use the regular mysql command line client (not PHPMyAdmin). It works fine on both Windows and Linux - Ed--
Thanks
Thanks alot for this. I've been looking all over for the bible in SQL format. Big plus for being MySQL ready!!! Great job!
-- You're welcome! --