homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Database Beginner.help!
Need some help with first steps...

5+ Year Member

Msg#: 109 posted 9:18 pm on Oct 25, 2005 (gmt 0)

Hey Everyone,

Well...already had gotten some good support with domain names so thought it was worth picking some more brains on this site! I'm working on the framework for my website which will be largely database driven. I'm reading Database Design for Mere Mortals (covers relational DBs) and am learning tons.

So here's the scoop...I'm in the process of designing the major fields and tables I'd want to populate, but beyond that I need help...

1. My DB will be far too large and dynamic to utilyze Access...so I figured MySQL (vs. paying tons for SQL or some other product). That a good way to go?

2. Assume I use MySQL...is there an easy way to set data up and then download it into MySQL? Not having used it I'm unsure how easy it is to enter thousands of records into a table.

3. I've read some about Navicat...is that a download tool for DBs? Sorry if it's a total newbie question!

4. If I were to use Navicat...is there an ideal program to use as my base...i.e. Excel or Access?

Sorry this is really newbie level stuff here, never having done this before I'm a little unsure how to proceed. I want to spend the extra time now to get it right the first time.

Any help or direction is sincerely appreciated! =)



WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 109 posted 9:56 pm on Oct 25, 2005 (gmt 0)

Hi and thanks for posting - we were ALL newbies at one time, so don't fret.

mySQL will be fine for what you want to do. And yes, you can easily import data into mySQL. If you like GUI tools, I would recommend mySqlFront (for windows).

I'm not familiar with Navicat, but it sounds like you need two programs to use it.

good luck with it!

R e b r a n d t

Msg#: 109 posted 8:05 am on Oct 26, 2005 (gmt 0)

I would recommend MySQL Administrator [mysql.com] and MySQL Query browser [mysql.com] first. They are nice, free tools made by MySQL team. Worth to try and see if they suit you (-;

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved