Re: [cobalt-users] MySQL

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

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

> My question - pre-empting any likely problems - is are their likely to be
> ownership issues with the way that I logged in and also what are .frm,
.ISD
> and .ISM files?

As long as the files work on your system they just need to be readable by
the owner that MySQL runs as.  If that user is "mysql", chown mysql:mysql
the files and chmod 600 will do the trick.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/