RE: [cobalt-users] MySQL

["Andy Jacobs" <andy.jacobs@xxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Steve Werby
> Sent: 06 February 2002 14:07
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] MySQL
>
>
> "Andy Jacobs" <andy.jacobs@xxxxxxxxxxxxx> wrote:
> > I am moving a site to my RAQ4 which is mainly PHP/MySQL driven.  When I
> got
> > the old site there was a directory which contained loads of
> .frm, .ISD and
> > .ISM files.
>
> Warning - if the source system is not similar in architecture to the
> destination (your RaQ4) it's likely those db files *will not* work on the
> destination box since those files are not designed to be portable across
> dissimilar system.  I'd advise using "mysqldump" (comes with
> mysql distro in
> its bin directory) to create dump files containing SQL statements
> which can
> be run to recreate the databases.  That's the right way to migrate
> databases.  It's also the right way to back them up.  Also, in the event
> they are portable between your two specific systems, keep in mind that
> copying the files while they are being written to will lead to corrupted
> files.  So you'll either need to shutdown MySQL on the source
> machine first
> or cross your fingers.

It's not critical at the moment as I am getting everything working on an
unused domain on the server to prove that it can be done and it *appears* to
be working.  But I will certainly remember that.

Andy