In a message dated 10/29/03 4:18:28 AM Eastern Standard Time, [EMAIL PROTECTED] writes:
> Ok, I've set my root password and have found (by creating a db) that > the databases are stored (Mac OSX Server 10.3) in /private/var/mysql. > > I have my old system on a separate hard disk; however, mysql is not > functioning there, but I do have my databases there. Can I copy these > database to their new home? How will MySQL recognize them? (What is > the best way in my situation to accomplish this move? (Again, MySQL is > not available to 'run' where they are.) I have not used Mac OSX, but I had a similar situation migrating my company to Linux from Windows2000 in our datacenter. I just moved the files over as I recall. You need to create a sub-directory under the DataDir (looks like under /private/var/mysql in your case) and I restarted MySQL. NOTE: All my tables were MyISAM. This may not work with InnoDB tables. HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
