Solved

MySQL Community Server interface

Posted on 2010-11-13
6
344 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
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

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.

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

825 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