• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

MySQL Community Server interface

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
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
  • 4
  • 2
1 Solution
 
printnix63Commented:
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
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
can i do it via prompt code
0
 
printnix63Commented:
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Mohammad Alsolaimanapplication programmerAuthor Commented:
"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
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
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
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now