Re: Copying Database from One Hard Drive to Another

2005-02-10 Thread love
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 f

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread David Blomstrom
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 > a

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread Victor Pendleton
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

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread David Blomstrom
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 vanish

Copying Database from One Hard Drive to Another

2005-02-08 Thread David Blomstrom
I've been using a preconfigured package (Apache, PHP, MySQL) from Apache Friends/XAMPP for several months. About a week ago, my computer crashed, and I'm now getting back on my feet. I downloaded the latest XAMPP, which features upgrades for PHP, phpMyAdmin and I think MySQL, too. Everything seems