472,353 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Importing Tables Using MySQL Control Center


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

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

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.

Jul 19 '05 #1
0 2358

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Oleg | last post by:
Hi, Not really a PHP specific question, but I am using PHP on Linux box so it's kinda relevant. I'm developing a site which will periodically...
by: Andrew Chalk | last post by:
I have some Visual Foxpro tables that I want to convert to tables in a MySQL database. VFP contains no MySQL export facility. Can anyone suggest a...
by: dilbir | last post by:
Hi, When I execute "LOCK TABLES 'ABC_0' WRITE" from control center, it is successfull, but when I execute this same query from MySql++ client I...
by: Harry | last post by:
Hello, I have the contents of a MySQL database sitting in a folder. Each file in the folder is an ISAM table that is comprised of three files, its...
by: steve | last post by:
Hi, I have researched but have not found a good solution to this problem. I am importing large amounts of data (over 50 Meg) into a new mysql db...
by: Bing Wu | last post by:
Hi all, I am running a database containing large datasets: frames: 20 thousand rows, coordinates: 170 million row. The database has been...
by: klh | last post by:
We are running on Win 2003/DB2 V8 FP7a. My question concerns Task Center. I have about 200 tasks created and scheduled in Task Center. We are...
by: JMO | last post by:
I can import a csv file with no problem. I can also add columns to the datagrid upon import. I want to be able to start importing at the 3rd row....
by: penny111 | last post by:
Hi there, I've migrated a database named "crime" from an MS Access database to MySQL 5.0.37 using the MySQL Migration Toolkit 1.1.11. What i want...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.