On Wed, 2004-05-12 at 14:35 +1000, Dean Hamstead wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > is it possible to copy a database from one mysql installation > to another by copying the files
That depends. Mysql has a couple of different on-disk formats. You'd need to make sure that the two installations were "compatible". In particular there's two different back-ends. InnoDB and... something else. It's a compile time option. I have successfully done this but in retrospect I realise it was mostly luck. > > obviously i could dump the database and reimport it > but thats not practical It's always been my experience that this is the less troublesome way to go. You'd wanna have a pretty good reason not to do it. HTH, James. -- James Gregory <[EMAIL PROTECTED]> -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
