Solved

MySQL Community Server interface

Posted on 2010-11-13
6
348 Views
Last Modified: 2012-05-10
Hi:
I install MySQL Community Server
I need to import a table from ms access
I have the prompt mode only
Any body help me to import my table please
Is this version has no GUI?
0
Comment
Question by:Mohammad Alsolaiman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 7

Accepted Solution

by:
printnix63 earned 500 total points
ID: 34127377
MySQL has a GUI "MySQL Workbench" and there are other GUI's out that can be used, as well.
MySQL has even some "data migrators" for various db's, so if it is only the table and date you'd be probably served well by these.
You might look at this article: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
at it's bottom you'll as well find links to the MySQL Workbench and other sources.

The other way round could be, to install the ODBC driver for MySQL and use the QBE-Interface from Access to get some work done.
0
 

Author Comment

by:Mohammad Alsolaiman
ID: 34127552
can i do it via prompt code
0
 
LVL 7

Expert Comment

by:printnix63
ID: 34128192
you can create the tables and import the data e.g. as CSV, so you need first the "CREATE TABLE..." sql scripts that you can then run in mysql and next import the CSV data (if you have it available in CSV) with a filter e.g by using mysqldump, which should be included in the package.

What exactly do you plan to do?
The basic installation of MySQL allows you to run anything sql based from the commandline.
mysql -u <user> -p <passw> -i < myownscript.sql
or import / export through the use of mysqldump etc.
For the migration you can use external tools, that is independent of wether you use prompt mode or run a GUI.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:Mohammad Alsolaiman
ID: 34128580
"The basic installation of MySQL allows you to run anything sql based from the commandline"
sounds good
can i have any example of creating a table of two columns using prompt mode .
and another example of importing a a table 'tblEmployee' for instance, from ms access mdb.
 
1.JPG
0
 

Author Comment

by:Mohammad Alsolaiman
ID: 34128711
While I am trying the SQLyog-8.6.3-0Trial
Try to import tables from ms access 2003
I get this err, file not found
See the attach picture (may u enlarge it please)

2.JPG
0
 

Author Closing Comment

by:Mohammad Alsolaiman
ID: 34129917
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question