question about Mysql

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
So, I used the mysql migration tool for the a db i designed in access. The migration tool found no problems. Anyways, I tried it on a db file that had about 8 tables. When it was done, I found a folder with the name of the db and files with the tablenames from the db. I am assuming the mysql keeps a db and its tables as a folder and files?

Thanks.
 

WildHorse

Diamond Member
Jun 29, 2003
5,006
0
0
It does, UNLESS you use the InnoDB table style, in which case it does not.
It does if you use MyISAM table style, which is faster, but doesn't yet support foreign keys (MySQL says MyISAM table style will support FK's in a future release).

Your installation probably defaulted to INNODB table type, which you can easily change to another type if you want to.

You can read all about this here.