Re: [SLUG] mysql databases

2004-05-12 Thread Dean Hamstead
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 success! thanks Dean Matthew Palmer wrote: | On Wed, May 12, 2004 at 02:35:43PM +1000, Dean Hamstead wrote: | |>is it possible to copy a database from one mysql installation |>to another by copying the files | | | Yes, but make sure you stop both data

Re: [SLUG] mysql databases

2004-05-12 Thread Matthew Palmer
On Wed, May 12, 2004 at 02:35:43PM +1000, Dean Hamstead wrote: > is it possible to copy a database from one mysql installation > to another by copying the files Yes, but make sure you stop both databases before beginning the copy, and that they've both stopped doing their thing before you start to

Re: [SLUG] mysql databases

2004-05-12 Thread Greg Cockburn
Dean, I have done it before. It worked. Greg On Wed, 12 May 2004 02:35 pm, Dean Hamstead wrote: > is it possible to copy a database from one mysql installation > to another by copying the files > > obviously i could dump the database and reimport it > but thats not practical > > i just want to

Re: [SLUG] mysql databases

2004-05-11 Thread James Gregory
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

[SLUG] mysql databases

2004-05-11 Thread Dean Hamstead
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 is it possible to copy a database from one mysql installation to another by copying the files obviously i could dump the database and reimport it but thats not practical i just want to copy the files from /var/mysql and drop them in on another machine c