Re: How do I construct tables from *.frm files?
Could you define "directly in MySQL"?
To my understanding there is nothing like "in" MySQL. MySQL is a database server that runs on a server machine and listens on a TCP/IP port.
On the client side you can use such tools as the MySQL command line or MySQL Query Browser to connect to the server running on that port.
As soon as you are connected with your user name you can start to write SELECT * FROM yourTable
The Migation Toolkit does this, too. It connects to the server and executes CREATE TABLE statements based on the original tables in Access. It never touches the *.frm files directly. It only talks to the server via SQL commands.
And you need to do the same. You cannot open the *.frm files in any application. The only one who understands them is the MySQL Server.
I hope this helps,
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Subject
Written By
Posted
September 08, 2005 04:05AM
September 08, 2005 12:45PM
September 08, 2005 02:43PM
Re: How do I construct tables from *.frm files?
September 09, 2005 12:31PM
September 10, 2005 05:32AM
September 14, 2005 02:51AM
September 14, 2005 07:30AM
September 14, 2005 03:47PM
September 15, 2005 03:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.