Can you import/export using MySQL Administrator?

[phillip.s.powell]

We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I need to know else
(e.g. Navicat)?

Thanks
Phil

[Bill Karwin]

<ph**************@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I need to know else
(e.g. Navicat)?

MySQL Administrator offers a GUI to create & restore database backups, which
is equivalent to a database export & import. It's virtually the same as
using mysqldump to create the backup and the mysql command-line tool to
restore the dump.

See:
http://dev.mysql.com/doc/administrat...or-backup.html
http://dev.mysql.com/doc/administrat...r-restore.html

Regards,
Bill K.

[phillip.s.powell]

That's not quite what we're looking for. We need to have the ability
to import an existing Access or MS SQL Server database, or export an
existing MySQL database to Access, without having for me to do command
line and export into a CSV or something.

I also found out that MySQL Administrator does not install on RHEL 4.

Phil

Bill Karwin wrote:

<ph**************@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I need to know else
(e.g. Navicat)?

MySQL Administrator offers a GUI to create & restore database backups, which
is equivalent to a database export & import. It's virtually the same as
using mysqldump to create the backup and the mysql command-line tool to
restore the dump.

See:
http://dev.mysql.com/doc/administrat...or-backup.html
http://dev.mysql.com/doc/administrat...r-restore.html

Regards,
Bill K.

[Bill Karwin]

<ph**************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

That's not quite what we're looking for. We need to have the ability
to import an existing Access or MS SQL Server database, or export an
existing MySQL database to Access, without having for me to do command
line and export into a CSV or something.
Aha. I misunderstood what you meant about import/export.

Well, MySQL also offers a tool called the MySQL Migration Toolkit:
http://dev.mysql.com/doc/migration-t.../en/index.html

This can move data from a MS Access or MS SQL Server (or others) to a MySQL
database.
I don't know if it does the reverse. I think it should, because it just
uses a JDBC connection to connect to both the source and the destination
database.
I also found out that MySQL Administrator does not install on RHEL 4.

Even though it's a Java application, MySQL Migration Toolkit has no
installation instructions for Linux; but you would need to run such a tool
on Windows anyway to connect to an MS Access database.

Regards,
Bill K.

[phillip.s.powell]

See below, thanx

Bill Karwin wrote:

<ph**************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

That's not quite what we're looking for. We need to have the ability
to import an existing Access or MS SQL Server database, or export an
existing MySQL database to Access, without having for me to do command
line and export into a CSV or something.
Aha. I misunderstood what you meant about import/export.

Well, MySQL also offers a tool called the MySQL Migration Toolkit:
http://dev.mysql.com/doc/migration-t.../en/index.html

This can move data from a MS Access or MS SQL Server (or others) to a MySQL
database.
I don't know if it does the reverse. I think it should, because it just
uses a JDBC connection to connect to both the source and the destination
database.

I also found out that MySQL Administrator does not install on RHEL 4.

Even though it's a Java application, MySQL Migration Toolkit has no
installation instructions for Linux; but you would need to run such a tool
on Windows anyway to connect to an MS Access database.

But that would only mean that it would allow for an import of a .mdb
file, right? Windows isn't necessary for that, just for allowing it to
interface with Access. And I thought OpenOffice has an Access
equivalent coming out.

Phil
Regards,
Bill K.

[Thomas Bartkus]

On Thu, 26 Jan 2006 07:45:15 -0800, ph**************@gmail.com wrote:

That's not quite what we're looking for. We need to have the ability
to import an existing Access or MS SQL Server database, or export an
existing MySQL database to Access, without having for me to do command
line and export into a CSV or something.

I also found out that MySQL Administrator does not install on RHEL 4.

You are looking for MySQL<->Access data xfer?
And you are familiar with MS Access?
Then MS Access *is* your GUI!

Just install the MySQL ODBC driver on the Windows machine and make linked
MySQL tables in Access.

Thomas Bartkus

[phillip.s.powell]

MySQL resides on a Linux box. The MS Access DB will reside on my
boss's WINXP laptop.

She requested to have the GUI interface installed on the Linux box,
since Access already has a GUI interface.

Phil

Thomas Bartkus wrote:

On Thu, 26 Jan 2006 07:45:15 -0800, ph**************@gmail.com wrote:

That's not quite what we're looking for. We need to have the ability
to import an existing Access or MS SQL Server database, or export an
existing MySQL database to Access, without having for me to do command
line and export into a CSV or something.

I also found out that MySQL Administrator does not install on RHEL 4.

You are looking for MySQL<->Access data xfer?
And you are familiar with MS Access?
Then MS Access *is* your GUI!

Just install the MySQL ODBC driver on the Windows machine and make linked
MySQL tables in Access.

Thomas Bartkus

[Bill Karwin]

<ph**************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

But that would only mean that it would allow for an import of a .mdb
file, right? Windows isn't necessary for that, just for allowing it to
interface with Access. And I thought OpenOffice has an Access
equivalent coming out.

http://dba.openoffice.org/ says:
"There is an alpha version of a MDB driver available. It currently has
read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4)
formats."

I wouldn't rely on such a bleeding-edge tool for business-important data.
And it's read-only anyway, so you can't transfer MySQL to .MDB -- in other
words, you don't gain anything over using the MySQL Migration Toolkit.

Anyway, I'm not sure how one could read an MS Access database that resides
on a Windows machine, by running any sort of application on Linux. Somehow
the Linux application would need to connect to the Windows host over the
network, and gain read/write access to the MDB file as a database. MS
Access doesn't implement a cleint/server interface for data access; it's a
GUI application that reads and writes MDB files local to the host running
the GUI, or at best on a network-mapped drive.

I don't know of a good solution for offering automatic bidirectional
synchronization between MySQL on Linux and MS Access on Windows.

A different solution might be for your boss to use MS Access forms as a
front-end to a MySQL database residing on her Windows XP laptop. Then you
could use MySQL Replication features to keep the two MySQL databases
synchronized.

Regards,
Bill K.