ISM tables are "old" structure for mySQL tables
they are called ISAM tables..
MYI tables are the new structures for mySQL tables
they are called MyISAM
This new structure offers better backup/restore
features along with better data sanity checking.
Not to mention, they are faster.
As for backing up a database, you should check into
mysqldump, it will create a dump file of your database.
However, if it's a large database, you may need a
diffrent route.
-johnny
-----Original Message-----
From: Asaf Maruf Ali [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 6:18 AM
To: [EMAIL PROTECTED]
Subject: MySQL data structure
Hello.
I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by
O'Reilly states that for a table named book under a
database Test following is the structure:
book.ISM
book.ISD and
book. frm
On my system MySQL 3.23.27 beta the structure is different.
book.MYI
book.MYD
book.frm
Any suggestions would be welcome.
Suggestions on backing up the MySQL db as well.
Anyone has experience of hosting MySQL/PHP ? Any recommended server/host/company?
Thanks in advance
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
