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?
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
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
"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
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
ASKER
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
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
i get more details in here
http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-examples-tools-with-access.html
thanks alot
http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-examples-tools-with-access.html
thanks alot
MySQL Server
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
49K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER