Web Hosting Talk







View Full Version : I don't get this....


kmurrey
02-22-2002, 04:21 PM
I have installed some PHP programs but I have now ran into a snag.

I wanted to install Netstatus 2.0 - but it says that I have to have databases installed.

How the heck do I do that? I have mysql installed and I am running phpBB2.

But I keep seeing programs asking me to create a db. Am I suppose to have multiple db's on my server for each program I run or is there one db that you create for all these different programs?

_______________________________
Keith

serve-you
02-22-2002, 06:09 PM
You can use one DB for multiple applications. This seems to be one of the biggest misconceptions around hosting right now. The only thing that you need to be sure of (any good programmer should do this already) is that the tables all have unique prefixes.

For example, if you look at your database, you will see that all of the tables for phpBB are prefixed with "phpbb_". This makes sure that if you install another program that has a table with the same name as one already in the db, there wont be any conflicts. Some programs will have a place for you to set the table prefix in the config file, others will already have something in place.

To use the same DB, just enter your existing DB name into the program's config file where it asks for the DB name.

-Dan

DigitalXWeb
02-22-2002, 07:42 PM
Funny this topic should arise.. I just had a situation with one of our clients who was using 2 poorly programmed scripts that did in fact overwrite one table of other script. Needless to say we had to restore the db and had a programmer fix the coding..

kmurrey
02-22-2002, 11:27 PM
I hope that you are not talking about NetStatus - :)

If you are please shed some light....

_____________________________
Keith

kmurrey
02-23-2002, 12:59 AM
Brian P.....

Also - thanks for the information. That makes my life alot easier. I have a little better understanding now.

_____________________
Keith

Marty
02-23-2002, 10:39 AM
Originally posted by kmurrey
I hope that you are not talking about NetStatus - :)

If you are please shed some light....

_____________________________
Keith

He is not talking about NetStatus. With all tables, Netstatus has an ns_ prefix on every name.

DigitalXWeb
02-23-2002, 01:31 PM
Originally posted by kmurrey
Brian P.....

Also - thanks for the information. That makes my life alot easier. I have a little better understanding now.

_____________________
Keith

Keith,

No problem glad I could help you out.. To answer your other question no it was not for NetStatus it was 2 seperate private coded scripts for a business we host.

kmurrey
02-23-2002, 08:12 PM
Brian:

Can you tell me how to stop 'other' people beside's me from getting to my netmanage directory on the web.

I want to be able to get there to setup the sites - but I don't want other people getting to it.

___________________
Keith

DigitalXWeb
02-23-2002, 08:16 PM
Originally posted by kmurrey
Brian:

Can you tell me how to stop 'other' people beside's me from getting to my netmanage directory on the web.

I want to be able to get there to setup the sites - but I don't want other people getting to it.

___________________
Keith

Protect it with an .htaccess file. You can either use a Password or if your ip is static that you will be using to connect to the server, you could also put that in which is the best method..

kmurrey
02-23-2002, 08:31 PM
Is there a standard .htaccess file that I can use?

Can I copy one from another location on my server?

What username / password is used when you try to access these directories that are .htaccess protected ?


_____________________
Keith

kmurrey
02-23-2002, 10:10 PM
I found one... image that... on this site...

____________________

Keith