469,578 Members | 1,401 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Importing Tables Using MySQL Control Center

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
Jul 19 '05 #1
0 2269

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Oleg | last post: by
2 posts views Thread by Andrew Chalk | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.