Hi ,
It seems there's a problem while the database is getting dumped coz it
gives an error saying that it was unable to create a particular ".frm" file.
Can't seem to figure out the reason. Any help would be really welcome. Could
there be a possible problem because of the foreign key constraints in the
table . In that case what would be the possible mechanism for porting data
from one database to the other "short of creating a manual script for it"?
Regards
Barry
From: "Christensen, Dave" <[EMAIL PROTECTED]>
To: "'Barry'" <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 8:14 PM
Subject: RE: INNODB data porting problem.
> What I would do in that case would be:
>
> 1) execute a CREATE <database>; command
>
> 2) execute the following command:
>
> mysqldump --add-drop-table <databasename> -uusername -ppassword |
> mysql --host=other.host.ip.addr <databasename> -uusername -ppassword
>
> This will effectively create a script that creates the schema and moves
data
> from one database to the other.
>
> -----Original Message-----
> From: Barry [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 09, 2003 9:20 AM
> To: [EMAIL PROTECTED]
> Subject: Re: INNODB data porting problem.
>
>
> Yes it still is a MySQL DB but not on the same system albeit another
system
> on the network.
>
> Regards
> Barry
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
