Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Database Beginner.help!

Need some help with first steps...



9:18 pm on Oct 25, 2005 (gmt 0)

10+ Year Member

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! =)


9:56 pm on Oct 25, 2005 (gmt 0)

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

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

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 (-;

Featured Threads

Hot Threads This Week

Hot Threads This Month