Ah, I see. So the tables that are represented by all three files are presumably MyISAM files, right?
--- Victor Pendleton <[EMAIL PROTECTED]> wrote: > InnoDB files can not be copied from one machine to > another like the > MyISAM files. If you did not dump the data or you do > not have an > archived backup you will more than likely have to > recreate the table > structures. > > > David Blomstrom wrote: > > >Yikes...I've been replying to myself! I forgot that > >when I reply to messages from the MySQL newsgroup > on > >this e-mail account, it doesn't include > >mysql@lists.mysql.com, for some odd reason. > > > >At any rate, I wanted to say that I have just ONE > file > >type left - FRM. My MYD and MYI files have both > >vanished. > > > >But I took another look and discovered that SOME > >tables are represented by all three files, and when > I > >paste them into my new MySQL > Data folder, they > work > >just fine. > > > >I also discovered the following files in my backup > >folder: > > > >ibdata1...215,040 KB > >ib_logfile1...5,120 KB > >ib_logfile0...5,120 KB > >ib_arch_log_000000000...25 KB > > > >Can these somehow be used to reconstitute lost > >database tables? The situation isn't critical, as I > >can recreate most of these tables from my original > >data, which is on spreadsheets. But recreating all > the > >fields and keys would obviously be a pain in the > butt; > >I had over 100 tables. > > > >Thanks. > > > > > > > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! Mail - Helps protect you from nasty viruses. > > >http://promotions.yahoo.com/new_mail > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
