PDA

View Full Version : Populating a database



ziltmilt
11-06-2008, 01:56 PM
I just created my first dbase on my domain ... how do i create tables & start populating them? i don't see an obvious way to interact w/ the dbase via the control panel. I'm used to SQL Server, so i was expecting some kind of online query tool.

My guess is that i'll have to set up the dbase via code, like PHP. Is that right?

thanks in advance -

Early Out
11-06-2008, 02:12 PM
Looks to me like you should hit cPanel, phpMyAdmin, Structure, where you can create tables. There's also an Import section for bringing in database files.

ziltmilt
11-06-2008, 03:35 PM
Thanks - that's the trick!!

But, now, i seem to have trouble adding tables. I keep getting a note at the top fo the page that cookies need to be enabled. I've gone into the 'privacy' tab on IE's settings and enabled all cookies, but after i enter a tablename and then define a field, the interface keeps telling me that there's no tables in my dbase.

Any suggestions? thanks again -

Early Out
11-06-2008, 03:42 PM
Offhand, I'd say "Use Firefox!" Maybe for IE you need to enable cookies, exit IE, launch it again, and then come back to cPanel. Just guessing....

ziltmilt
11-06-2008, 04:43 PM
Is it normal to see this message at the top of the phpMyAdmin page:

'Cookies must be enabled past this point.' ?

I tried using Firefox like you suggested and cookies are enabled on this browser, cause i can see existing ones in the privacy settings. Still, i'm having no luck getting a table created.

ziltmilt
11-06-2008, 04:48 PM
I haven't been defining a Collation value. This is just a plain-Jane, US English dbase ... i have no idea what value i should use here.

ziltmilt
11-06-2008, 06:43 PM
Aha!! got it - it was my pesky firewall, not my browser or some obscure setting i missed on the interface.