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.
Powered by vBulletin® Version 4.1.10 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.