InnoDB

"Shaun van Wyngaard" <[email protected]> Mon, 17 Sep 2007 09:32:53 +0200
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
------=_NextPart_000_000D_01C7F90D.B94D7220
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello
 
Please correct me if I'm wrong.
 
We previously had a mySQL server installed on the default C:Drive.
We have now upgraded to a new box with a faster processor, new drives,
etc. I have taken the C:Drive out of the original box, and slaved it
into the new box.
I will install mySQL on the new box's C:Drvie. My backups are a couple
of days old, so I want to transfer the databases as they exist to the
new system drive.
I will copy the directories containing the databases from under the data
directory (slave drive) to the newly installed data directory. I will
also copy over the ibdata1 file, as well as the my.ini file.
This will then give me working databases again?
 
I tried this on my own computer, and it seems to work, but I want to be
sure.
 
Thanks you
 
 
Shaun van Wyngaard
 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


------=_NextPart_000_000D_01C7F90D.B94D7220--