Solved

MySQL Community Server interface

Posted on 2010-11-13
6
347 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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://…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

763 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