87,000+ Lyrics Database for Sale!

[Mr.Domains]

Many of you may remember, or even bought, my 11,000 Cheat Codes database. I sold many copies here on DNforum and had many happy customers! :-D

Well, I've just finished compiling a Song Lyrics database, which is now ready for sale. It contains nearly 90k song lyrics by over 1000 artists. This is not an existing database that I bought on here or another forum, it was painstakingly collated by myself, and so far, no other copies of it exist!

If you would like to have a look at the quality of this database, it is currently powering my new site:

LyricsToTheSong.com

(The site isn't finished yet, but the database is all there, exactly as sold).

I am selling copies of this database for $40 PayPal.

If you want to build your own Lyrics website this database is all you need to get started!

Please don't hesitate to PM me or post your questions below.
I am also open to trades for other databases, scripts, domains or services!

[haynes8]

Is it sql, how hard will it be to put the info into an existing forum?

Thanks

[Mr.Domains]

It's MySql, and takes the form of SQL commands, so that you can insert it directly into your database using cpanel and PhpMyAdmin. It has the usual "Alphabet Letter/#", "Artist", "Title", and "Lyrics" fields, plus some extra fields for SEO purposes, (URL escaped "Artist" and "Title" fields), which you can delete if you don't need. The table layout and records look like this:

-- Table structure for table `lyrics`
CREATE TABLE `lyrics` (
`id` bigint(21) NOT NULL auto_increment,
`letter` char(1) NOT NULL default '',
`artist` varchar(50) NOT NULL default '',
`artist_esc` varchar(50) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`title_esc` varchar(255) NOT NULL default '',
`lyrics` text NOT NULL,
`hits` bigint(21) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `letter` (`letter`,`artist_esc`,`title_esc`),
FULLTEXT KEY `artist` (`artist`,`title`,`lyrics`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=87545;

-- Example data for table `lyrics`
INSERT INTO `lyrics` VALUES (1, 'A', 'A Perfect Circle', 'a-perfect-circle', '3 Libras', '3-libras', 'Threw you the obvious and you flew with it on your back<br>A name in your recollection down among a million same<br>Difficult not to feel a little bit disappointed and passed over<br>When I’ve looked right through to see you naked but oblivious<br>And you don’t see me<br>But I threw you the obvious just to see<br>If there’s more behind the eyes of a fallen angel eyes of a tragedy<br>Here I am expecting just a little bit too much from the wounded<br>But I see see through it all see through and see you<br>Cause I threw you the obvious to see<br>What occurs behind the eyes of a fallen angel eyes of a tragedy<br>Oh well apparently nothing, apparently nothing at all<br>You don’t see me you don’t see me at all', 1);

If you know any SQL then it's fairly easy to write a query to copy the data out of this database and into your existing tables, in whatever format you need it in.

Thanks for taking an interest haynes8!

[haynes8]

I may buy one, I need to figure out if I can install it first. I hate phpmyadmin etc. makes my blood pressure go outta sight.

[SouthernTn]

Originally Posted by haynes8

I may buy one, I need to figure out if I can install it first. I hate phpmyadmin etc. makes my blood pressure go outta sight.

its easy.. basically just uploading it

[Mr.Domains]

Yes, create a database first, then in PhpMyAdmin select the SQL tab, just upload the file. That's it!