Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
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! =)
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!