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

["Patrick Hunter" <hunterp@xxxxxxxxxxxxxx>]

Simply moving the files will not get you a functional database and tables. The best way is to do a dump of the old database and then transfer the dump file to 
your new machine and then tell mysql to import the dump file. Here is what you need to do.

1) Create a database with the same name as the old database on the old machine on the new machine, ie. if your original database is DataProducts, then 
the new database name will also be DataProducts.

2) On the old machine execute the following command, "mysqldump DataProducts > DataProducts.sqldump -p"    You will be asked for the administrator 
password and it will then create the dump file.

3) Transfer the dump file to your new machine.

4) Execute the following command "more DataProducts.sqldump | mysql DataProducts"    You may need to add the -u and -p arguments to this statement so 
that mysql is logged in correctly.

5) You will then need to recreate the users and priviliges in order to regain the access they had on the old server.




On Wed, 27 Dec 2000 12:23:08 -0500, ebryan@xxxxxxxxxxx wrote:

>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
>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.  
>
>_______________________________________________
>cobalt-users mailing list
>cobalt-users@xxxxxxxxxxxxxxx
>To Subscribe or Unsubscribe, please go to:
>http://list.cobalt.com/mailman/listinfo/cobalt-users
>


Patrick Hunter, Fusionwerx
www.fusionwerx.com
hunterp@xxxxxxxxxxxxxx