Well if you copy my.cnf settings along with ibdata files and log files
then it is possible to copy innodb exactly on the different machine and
i have done this before worked fine for me.
Love ..
[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]
The information transmitted is intended only for the person or entity
to whom it is addressed and may contain confidential and / or
privileged Material. Any review, re-transmission, dissemination or
other use of or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from your computer. Thank you for your
understanding & co-operation.
