I'm building a virtual machine running Red Hat Linux 9 (Shrike) and MySQL. This is to virtualize a current production system that needs new hardware. Questions:
Can I copy the existing mysql daemon executables to the new machine from the old one and if so, where are they located, and what is involved?
Are their archived packages of the early mySQL packages? I was hoping to find the exact version running on my old server, to do an install, and the copy the database file.
Hi..... many thanks for the ideas. I'm pretty sure the copy is the way to go.... (thanks Tometzky), but it is somewhat fraught, as the old hardware has a software RAID array, so I'm not sure I can do a bitcopy and have it work. And, the original mySQL is 3.23 (just about the first production version....). Earliest source I've found was at SkyServer which started at version 4.x.
A dd from one /dev/sda to /dev/sdb seems to work fine (simulated in VirtualBox). So far an /dev/md0 (from a RAID 1 drive) doesn't work....but I'm going to try copying partitions individually, and then see if that will work.
Our original mySQL is 3.23 (just about the first production version....). Earliest packaged binaries at SkyServer are 4.1
Obviously, this is a temporary move to buy us some time while we re-write the applications that query the mySQL.