Intalling 'blog'

[boxturt]

I was going to try using movable-type for my 'blog' but I only managed to make a mess of it several times. So I went looking for something a little simpler and came across Blog by Jonathan Beckett and it seems simple enough except for one line in the instructions :

 

Run the SQL in database.sql (supplied) through your database.

 

The contents of that file are :

# MySQL SQL Script

 

CREATE TABLE blog (

  nIdCode bigint(20) NOT NULL auto_increment,

  dEntryDate datetime NOT NULL default '0000-00-00 00:00:00',

  cTitle varchar(100) NOT NULL default '',

  cBody mediumtext NOT NULL,

  nViews bigint(20) NOT NULL default '0',

  nComments bigint(20) NOT NULL default '0',

  UNIQUE KEY nIdCode (nIdCode),

  KEY dEntryDate (dEntryDate)

) TYPE=MyISAM COMMENT='Journal Table';

 

 

CREATE TABLE blog_comments (

  nIdCode bigint(20) NOT NULL auto_increment,

  nBlogId bigint(20) NOT NULL default '0',

  cUsername varchar(75) NOT NULL default '',

  cEMail varchar(75) NOT NULL default '',

  cURL varchar(150) NOT NULL default '',

  cComment mediumtext NOT NULL,

  UNIQUE KEY nIdCode (nIdCode)

) TYPE=MyISAM;

 

I really don't have any idea what is meant by that. Help please?

 

Ty

[vendlus]

*edit* sorry, double post

[vendlus]

go to your cPanel and select 'phpmyadmin' from the bottom right.

 

Select your database on the left.

 

Click on the 'SQL' at the top of the main pane.

 

Either copy that SQL statement into the large textarea there and click 'Go'.... or use the smaller text field below it to select the 'database.sql' file that you have and click 'Go'. Either one should do the same thing.

 

That's it. You should get a success screen from there.

[surefire]

Good job vendlus... you obviously know your way around a database... don't you?

[vendlus]

Well, I started off by using SQL Server a few years ago. I had planned to get my MS cert for it, but haven't gotten around to it yet.

 

The site I'm creating is going to be heavily driven by mySQL, so almost all of the coding I've been looking at for the past good while is database code. Since the people who will be helping on the site are mostly database newbies, I've been spending a lot of time writing pages so that they never have to see a query string or care how the tables are connected. Stare at it long enough and you get to know what's going on.

 

It's a good thing I really enjoy it, or I'd go nuts.... now if I could only get someone to pay me to do it....

[boxturt]

Thanks Vendlus. You were very clear and it worked perfectly.

 

Unfortunately I wasn't real impressed with the blog itself so the little boxturtle will continue his slow but steady search!

[Guest schussat]

Unfortunately I wasn't real impressed with the blog itself so the little boxturtle will continue his slow but steady search! 

You mentioned trying Movabletype but not having any success. I'm running MT, and would be happy to help you out, if you want to give it another try.

 

-Alan

[boxturt]

Thank you very much Alan, I may just take you up on that!!

 

And in all fairness to the author of the aforementioned blog script - it really is quite nice and easy to use, just not quite what I wanted.

 

-,^^,o

[boxturt]

I finally decided upon LiteBlog from Source Forge. It's very simple (good for me) and basic. With a few changes I was able to get it pretty much the way I want it. Is more a chronicle than anything else and has the ability to turn off the 'comment' feature.

 

Not far along yet but here it is.

 

Thanks again