Re: [cobalt-users] Moving mysql tables to Raq4

[jens@xxxxxxxxxxxxxxxxxxxx (Jens Kristian Søgaard)]

> I am transitioning from a Raq2 to Raq4.  I have many mysql databases.  I
> have copied the ISM,ISD and frm files and moved them to the new server.
> The databases and all tables and data are recognized.  I can select but
> cannot insert as the tables are all found to be 'read-only' by the new

Check the permissions of the files on the RaQ4.

I assume, that you have to run a command like this in the mysql data
dir:

        chown -R mysql.root *

Which would assign ownership of the files to the mysql user (I assume
that you use safe_mysqld).

> installation of mySQL.  Does anyone know how I can fix this?  If I use the
> Load Data function I will have to recreate all the tables and this is a
> huge, repeat huge, project.  Would save me mega-hours of work to be able to
> get them recognized on the new server.  

You should really consider using the mysqldump utitlity to dump the
tables, and then the mysql utility to re-import them. If you have any
binary data in the tables, then it however may not be a good idea.

Using mysqldump handles creation of the tables, so you do not need to
worry there. It also gives you tables a nice "clean" starting point,
which (on large databases) would give you a better performing
database.

You should also consider analyzing and myisamchecking your tables on
the new server before having finalized the move.

-- 
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@xxxxxxxxxxxxxxxxxxxx,
http://www.mermaidconsulting.com/