Avatar of Mohammad Alsolaiman
Mohammad AlsolaimanFlag for Saudi Arabia asked on

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?
MySQL Server

Avatar of undefined
Last Comment
Mohammad Alsolaiman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
printnix63

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mohammad Alsolaiman

can i do it via prompt code
printnix63

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.
ASKER
Mohammad Alsolaiman

"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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
Mohammad Alsolaiman

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
ASKER
Mohammad Alsolaiman