Hi,
I'm completely new to MySql and need help importing tables from Access or
Dbase. I am using Dreamweaver MX to create a data-driven web site. With the
VPS hosting plan we're on, our remote FreeBSD server only supports the PHP
application server. PHP requires MySql. Thus, I installed a copy of MySQL
Control Center 0.9.2 beta. (I prefer a GUI and not command prompts unless
necessary.)
The information I plan on using in developing this site will be derived from
a contact management program called GoldMine. The records will be exported
into DBase tables, and somehow imported into the MySQL/PHP/Dreamweaver
environment.
From what I can gather so far, the MySQL environment I'm working under will
not work with Access or DBase tables. Thus, I've created a new table in
MySQL and re-created the various fields to match what I have in the DBase
table. Now I want to import all the records I have in my DBase table. In
fact, I will need to update the MySQL database weekly.
So far, I have been successful in making all the connections work, except
for importing the table into MySQL. In the MySQL Control Center, once you
connect to the database, there is an option to import, but it is dimmed out.
How do I make it work?
Thank you for any assistance you can provide.
Rick