My Own Database

LiamMcilveen · 01-11-2007, 12:40 AM

When you sign up for a hosting account, you recieve a certain amount of space, subdomains and domains. You also are given database. What i want to know is if you feel the database you were give insuficiant, etc... can you create your own using your own program/files on the server file space (Accessed in File Manager)

I am wondering would you be able to do such a thing?

If it would be possibile or there is a program/freeware/shareware out which would do this could someone let me know what it is and how to go about setting an independant db like up?

Thanks LiamMac

Skie · 01-11-2007, 02:12 AM

Why do you feel the database is insuficiant? Most webhosts will provide mySQL, MSSQL or MS Access (yuck). The first 2 are more then sufficiant to do just about anything you need. The 3rd... I won't even mention it further... Some hosts may provide PostgreSQL or even Oracle, but not many do. However, you won't be able to install your own database unless you have a dedicated server or a VPS. Both will require root/Admin access.

LiamMcilveen · 01-11-2007, 02:32 AM

Ok thanks, just an idea.

Skie · 01-11-2007, 11:13 AM

You can try asking your server admin/host to see if they would be willing to allow you to use a specific database, but that would be the best you can do for a shared hosting environment.

LiamMcilveen · 01-11-2007, 04:41 PM

The situation is a free hosting account with 100mb file space and one free database of 10mb. As I am only using 30mb of the file space and needed more database room was why I was looking for an alternative. I doubt a free account will be given any special attension to do with adminstration etc...

Skie · 01-11-2007, 07:30 PM

If that's the case, then I don't think so.

LiamMcilveen · 01-11-2007, 08:32 PM

Ok thanks anyhow. I am just looking for ideas. Without access to a paid account or money to do so you have to be quite creative with your solutions.

MattBro · 01-14-2007, 08:05 AM

When I develop software (Including that which is used by websites) I never use the "buisness standard", such as MySQL, dBase, ect...

(If possible) Write your own DBMS.

LiamMcilveen · 01-14-2007, 05:08 PM

I am novice when it comes to webdevelopement.

I find myself having to follow help from others etc.

.Smokin.Guns. · 02-25-2007, 09:23 AM

Quote:

Originally Posted by MattBro

When I develop software (Including that which is used by websites) I never use the "buisness standard", such as MySQL, dBase, ect...

(If possible) Write your own DBMS.

Still. MySQL is the standard. Most pre-written scripts are already compatible with it.

And as for the question at hand, in order for you too be able to host your own db system...you would have to have full root access and know your way around linux to install it. Im guessing your running cpanel (unless i missed that). The only way to do this is either, A) have a web hosting account that has full root access (not usual) or B) your own web server. Until then, i would just stick with MySQL and PhpMYAdmin:P

LiamMcilveen · 02-26-2007, 08:38 PM

Yeah I have kinda given up on that idea. I don't think I will go to all the trouble of getting a host that will allow root access, so yes PhpMyAdmin will work for now. But thanks everyone.

01-11-2007, 12:40 AM	#1 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	My Own Database When you sign up for a hosting account, you recieve a certain amount of space, subdomains and domains. You also are given database. What i want to know is if you feel the database you were give insuficiant, etc... can you create your own using your own program/files on the server file space (Accessed in File Manager) I am wondering would you be able to do such a thing? If it would be possibile or there is a program/freeware/shareware out which would do this could someone let me know what it is and how to go about setting an independant db like up? Thanks LiamMac

01-11-2007, 02:12 AM	#2 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Downers Grove, IL Posts: 1,821 OS: Gentoo Linux, Redhat Enterprise Linux, CentOS My System	Why do you feel the database is insuficiant? Most webhosts will provide mySQL, MSSQL or MS Access (yuck). The first 2 are more then sufficiant to do just about anything you need. The 3rd... I won't even mention it further... Some hosts may provide PostgreSQL or even Oracle, but not many do. However, you won't be able to install your own database unless you have a dedicated server or a VPS. Both will require root/Admin access. __________________

01-11-2007, 11:13 AM	#4 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Downers Grove, IL Posts: 1,821 OS: Gentoo Linux, Redhat Enterprise Linux, CentOS My System	You can try asking your server admin/host to see if they would be willing to allow you to use a specific database, but that would be the best you can do for a shared hosting environment. __________________

01-11-2007, 07:30 PM	#6 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Downers Grove, IL Posts: 1,821 OS: Gentoo Linux, Redhat Enterprise Linux, CentOS My System	If that's the case, then I don't think so. __________________

01-11-2007, 02:32 AM	#3 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	Ok thanks, just an idea.

01-11-2007, 04:41 PM	#5 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	The situation is a free hosting account with 100mb file space and one free database of 10mb. As I am only using 30mb of the file space and needed more database room was why I was looking for an alternative. I doubt a free account will be given any special attension to do with adminstration etc...

01-11-2007, 08:32 PM	#7 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	Ok thanks anyhow. I am just looking for ideas. Without access to a paid account or money to do so you have to be quite creative with your solutions.

01-14-2007, 08:05 AM	#8 (permalink)
MattBro Registered User Join Date: Nov 2006 Location: Sydney, Australia Posts: 202 OS: WinXP-Home	When I develop software (Including that which is used by websites) I never use the "buisness standard", such as MySQL, dBase, ect... (If possible) Write your own DBMS.

01-14-2007, 05:08 PM	#9 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	I am novice when it comes to webdevelopement. I find myself having to follow help from others etc.

02-26-2007, 08:38 PM	#11 (permalink)
LiamMcilveen Registered User Join Date: Nov 2006 Posts: 18 OS: Win2k	Yeah I have kinda given up on that idea. I don't think I will go to all the trouble of getting a host that will allow root access, so yes PhpMyAdmin will work for now. But thanks everyone.