Re: How do I construct tables from *.frm files?

[Michael G. Zinner]

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