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
news:1138216295.252955.316500@g14g2000cwa.googlegroups.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/administrator/en/mysql-administrato r-backup.html
http://dev.mysql.com/doc/administrator/en/mysql-administrato r-restore.html
Regards,
Bill K.
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:
>
> news:1138216295.252955.316500@g14g2000cwa.googlegroups.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/administrator/en/mysql-administrato r-backup.html
> http://dev.mysql.com/doc/administrator/en/mysql-administrato r-restore.html
>
> Regards,
> Bill K.
news:1138290315.489238.124880@f14g2000cwb.googlegroups.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-toolkit/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.
See below, thanx
Bill Karwin wrote:
>
> news:1138290315.489238.124880@f14g2000cwb.googlegroups.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-toolkit/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.
On Thu, 26 Jan 2006 07:45:15 -0800, phillip.s.powell@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
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, phillip.s.powell@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
news:1138297521.276729.262740@g44g2000cwa.googlegroups.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.