Business help and advice forum for starting and growing small businesses - Teneric Business Forums
Login Register FAQ Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools
(#1)
Old
Nizmo Offline
Business Planning
 
Posts: 14
Join Date: Sep 2006
Mysql database creation help - Not creating a database - 10-09-2006, 06:35 PM

Hi

I have signed up to some free webhosting, as I want to practice using some shopping cart software, but I now want to install it but i first need a database

I logged on to the cpanel X admin area, then go to Mysql database, went to create one, gave it a name, etc, then it says that created a database with the name, then I go back and the database is not there, its basically looks like its doing nothing, does not show any databases I have created.


Anyone know what the probem may be ?


Thanks

nizmo
Reply With Quote

(#2)
Old
PatrickH Offline
Business Startup
 
Posts: 18
Join Date: Sep 2006
Location: London
Re: Mysql database creation help - Not creating a database - 11-09-2006, 10:06 PM

Hello nizmo

Cpanel is not the easiest of tools. It is likely that you have created a database. It will be an empty one i.e., one with no tables and no data. Your next step is to create a table or tables.
You can do that by running a (Eg) PHP script against the database. Then you can populate the table(s) with data.
Your CPanel admin home page (the one you get on admin login) should have a shortcuts tab. Click on that to go to the MySQL admin tool. You should check whether you are allowed to use db admin software - if yes, the PHPMyadmin is free (open source) and relatively easy to use for creating tables, inserting data,etc..

It is important to understand that MySQL is a database server - your db will be one of many sharing the MySQL space. So you are restricted as to what your host allows you to see.
Hope this helps. You can PM me if you want more info
regards
Patrick
Reply With Quote
(#3)
Old
peterjhale's Avatar
peterjhale Offline
Small Business Guru
 
Posts: 2,498
Join Date: May 2004
Location: Cookham, UK
Send a message via Yahoo to peterjhale
Re: Mysql database creation help - Not creating a database - 11-09-2006, 10:58 PM

generally you set you db up first and cpanel will give you a db name like yoursite_databasename

then create a user and your username will be yoursite_yourusername and you need to assign the user to your new database

then again generall you should edit a config.php file with your shopping cart s/w where you tell it the empty db you have just set up.

It should then create all the tables for you and away you go !


Starting a new business and need finance?
Click here to get a free business plan template
Reply With Quote
(#4)
Old
Ender Offline
Business Director
 
Posts: 59
Join Date: Aug 2006
Location: London UK
Re: Mysql database creation help - Not creating a database - 12-09-2006, 05:35 PM

Hi Nizmo,

Maybe you could approach it from a different direction by installing a more user friendly application such as Wordpress? That's easy peasy to set up!
Reply With Quote
(#5)
Old
Nizmo Offline
Business Planning
 
Posts: 14
Join Date: Sep 2006
Re: Mysql database creation help - Not creating a database - 12-09-2006, 05:40 PM

Could you tell me more about wordpress ender ?


Thanks
Reply With Quote
(#6)
Old
Ender Offline
Business Director
 
Posts: 59
Join Date: Aug 2006
Location: London UK
Re: Mysql database creation help - Not creating a database - 12-09-2006, 08:24 PM

Hi,

it's blogging software that runs under php with a MYSQL database.

http://wordpress.org/

I'm experimenting with it myself
http://www.travel-niche.com/blog/
and it was ever so easy to set up.

If you get stuck I have a dormant account you can use for a few weeks. I'm too busy to use it now, but I would ask that we set up a password on the account to prevent it being spidered by the search engines. Send me a PM if you are interested.

Cheers,
Ender.
Reply With Quote
(#7)
Old
Nizmo Offline
Business Planning
 
Posts: 14
Join Date: Sep 2006
Re: Mysql database creation help - Not creating a database - 15-09-2006, 01:36 AM

THanks for all the help guys,

It turned out that it took 3 days for the hosting to get activated properly, so now everything works as it should.

Thanks, especially ender for offering all his help
Reply With Quote
(#8)
Old
CanzDesign Offline
Business Director
 
Posts: 88
Join Date: Nov 2006
Location: New Zealand
Send a message via MSN to CanzDesign
Re: Mysql database creation help - Not creating a database - 12-11-2006, 12:08 AM

Hi there.

Glad to hear all is going well now.

But just for interest what shopping cart are you trying out, and how's it going?

We have our own CMS purpose build for our specific use of displaying and selling photos, but I have been looking around at various shopping carts, and CMS sites and most of them seem to be terribley hard to use.

I'm one of those people, that can usally open a program and work out how to use it within a couple of hours, and theres always a grumble when I have to use helpfiles, the whole office is in an uproar, if anyone notices I actually reading a helpfile I have yet to find any help in one after five years. So not being about to use these shopping cart and CMS programmes is a new thing for me, I guess I'm so used to the easy of use for our own one, that I've been spoilt lol


Lynn CanzDesign
Reply With Quote
(#9)
Old
PatrickH Offline
Business Startup
 
Posts: 18
Join Date: Sep 2006
Location: London
Re: Mysql database creation help - Not creating a database - 14-11-2006, 09:29 PM

Shopping carts vary a lot - but the basics are not difficult. Have a look at one I've built as a demo (not complete yet) where I intend to provide an explanation and guide for small businesses to maintain their own site.
www.pthickey.org.uk/demoshop
Reply With Quote

Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0 ©2007, Crawlability, Inc.