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 copy the files from /var/mysql and drop
 them in on another machine

 can this be done, i assume i need to tell mysql about the
 new files?

 Dean
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

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 copy.

- Matt
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

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 databases before beginning the copy, and
| that they've both stopped doing their thing before you start to copy.
|
| - Matt
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAodhVI1HDX08lY+ARAnF6AKCdGJJF2dPJAvZHHdT/NCMIWfjhWACg28lC
uaOoQR5XoX+GsWd+due8mic=
=E7ZL
-END PGP SIGNATURE-
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[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
can this be done, i assume i need to tell mysql about the
new files?
Dean
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAoameI1HDX08lY+ARAkaYAJ9mhb7Ni8ZOd2YNaM41jRV6GDX4qgCg2/3p
CvliGOCzEAJJH/JzoVN4scU=
=hP9V
-END PGP SIGNATURE-
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

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 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