Elmar,
The reason you could not find any documentation about how MySQL connects to
other databases is because MySQL does not connect to other databases
(except in the special case of replication between MySQL servers). What
you have is a program, Excel, contacting a database through an ODBC driver.
Excel, in this case, is acting as your GUI to the data.
Let me see if I understand your situation correctly:
a) You have a program on your Palm that tracks repair jobs in a
HanDBase 3.0 database.
b) You would like to be able to analyze that information using the
MySQL query engine.
Before you can use MySQL to analyze any data, that data must be exist in
MySQL. You should probably create a new database in MySQL to house your
repair job information. Then you will need to populate that database with
the data from your other database. I don't know about anyone else on the
list but I do not have enough information to be more specific. There may be
a utility program available that could automate the entire migration but I
can't think of any.
One of the most basic, but sometimes the hardest to get just right,
techniques in data migration is to export (dump) all of the data from one
database system to a text file then re-import that data into the new
system. You may have to dump each table to a separate file. You will
probably need to hand-create your destination tables in MySQL in order to
have an appropriate location to store the incoming data. You may need to
adjust the output and input settings (quoted identifiers, field boundaries,
row boundaries, etc.) several times before you get a clean transfer.
You could write a script that reads data from your HanDBase database
(through its specific ODBC driver) and copies that data into a MySQL
database (through the MySQL ODBC driver) but I don't know how good a
developer you are.
I am sorry I could not be more help but migrations like these are typically
quite "messy".
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
|---------+---------------------------->
| | Elmar and |
| | Madeleine von |
| | Muralt |
| | <[EMAIL PROTECTED]|
| | .com.au> |
| | |
| | 07/06/2004 08:02 |
| | PM |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Fax to:
|
| Subject: Connect to other database format
|
>--------------------------------------------------------------------------------------------------------------------------------|
Hi,
I'm completely new to MySQL and some of its concepts, therefore, these
questions may be very basic.
To connect to another database format I need the ODBC driver for that
other format - right?
I've built a repair job entry database on my Palm with HanDBase 3.0. I
also got the HanDBase ODBC Driver v3.0. I tried to connect my desktop
database program Paradox to it but there are some issues which seem to
be unsolvable. I tried to connect to the .pdb (HanDBase) tables with
Excel - that worked. Presumably, this indicates that the HanDBase ODBC
driver is doing its job.
What I would like to do is to copy the .pdb tables into MySQL tables and
then work with these MySQL tables on the desktop. I searched hi and lo
but all the connection related info seems to be about other database
programs connecting to MySQL but I could not find any info about how
MySQL connects to other database formats.
Thanks for any help with this.
Elmar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
