472,965 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Can you import/export using MySQL Administrator?

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

Jan 25 '06 #1
7 33323
<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.
Jan 26 '06 #2
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.


Jan 26 '06 #3
<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.
Jan 26 '06 #4
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.


Jan 26 '06 #5
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

Jan 26 '06 #6
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


Jan 26 '06 #7
<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.
Jan 27 '06 #8

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

Similar topics

2
by: Damien | last post by:
Hi to all, I need to design an import/export system. Data comes from a filemaker pro DB in a big CSV file. Some alterations are made on the data as it is imported into my mysql table. Data is...
5
by: steve | last post by:
Hi, When I copy tables in a database from one server to another using enterprise manager, everything copies ok, except for field defaults. Has anyone seen this, and what is the solution? --...
2
by: Pat | last post by:
Hi, I installed Mysql Administrator with file mysql-administrator-1.0.22a-1.rh9.src.rpm from the mysql-site on my RedHat 9.0 computer I did: rpm -Uvh mysql-administrator-1.0.22a-1.rh9.src.rpm...
0
by: timothy.williams | last post by:
Hi. We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything...
10
by: Simon | last post by:
Hi, I need to export a 200MB database from one domain to another. phpMyAdmin timeout after a while and is not ideal. I don't mind spending money if I have to but this is rather urgent. I...
0
by: sjohnson | last post by:
Thanks for the help in advance, It has been over 5 years since I have messed with FreeBSD and I have never messed with MySQL until now so forgive me if my issue is trivial and I thank everyone...
2
by: martha70 | last post by:
Iím running PHP MySQL (zen-cart) Iím looking for info on CSV files with data sets and how I can import these into MySQL. I found a number of topics involving simple CSV files and I tried a number of...
1
by: InvestorTrade | last post by:
Hi, I've been trying to export/import a table from a DB with Chinese_PRC_CI_AS collation, and I can't seem to get it working at all - the export seems rather simple, it is the import that is not...
1
by: stack | last post by:
Hi all, How can I see/change permissions to alter table data using MySql Administrator? Of course I googled it first but I can't find the answer. Thanks!
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.