List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 26 2008 6:56pm
Subject:Re: mysqldump
View as plain text  
In the last episode (Jul 26), John Nietzsche said:
> i am in need to migrate a database between two mysql server. The
> server source is running mysql 4.0.18-log, the destination server is
> running mysql 5.0.51a-log.
> 
> I dumped the database (in the server source) using mysqldump utility.
> The command i issued in de source sever was:
> robigo$ mysqldump -u root -probigoroot genweb > s.sql
> 
> It worked alright, but when i try to restore (s.sql) in the server i,
> mysql (client utility) complains on error and exit, here is the
> output.
> 
> robigo$ mysql -u jpaulo -paivALF genweb < genweb
> ERROR 1005 (HY000) at line 11: Can't create table
> './genweb/contigs.frm' (errno: 150)
> robigo$

$ perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed

I wonder if a 4.0 mysqldump isn't directly processable by a 5.0 server?
Try running the mysqldump command from the 5.0 server, and connect to
the 4.0 server with the -h option.

-- 
	Dan Nelson
	dnelson@stripped
Thread
mysqldumpJohn Nietzsche26 Jul
  • Re: mysqldumpDan Nelson26 Jul
    • Re: mysqldumpJohn Nietzsche26 Jul
      • RE: mysqldumpMartin Gainty27 Jul
      • RE: mysqldumpMary Bahrami28 Jul