List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:July 27 2008 1:07am
Subject:RE: mysqldump
View as plain text  
John and Dan-

would have to see your constraint statement preferably the CREATE TABLE statement to make
any kind of intelligent assessment here..

Martin Gainty 
______________________________________________ 
Disclaimer and confidentiality note 
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission. 


> Date: Sat, 26 Jul 2008 16:30:55 -0300
> From: john.nietzsche@stripped
> To: dnelson@stripped
> Subject: Re: mysqldump
> CC: mysql@stripped
> 
> sioux@robigo$ mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
> -- MySQL dump 10.11
> --
> -- Host: 200.18.142.98    Database: genweb
> -- ------------------------------------------------------
> -- Server version       4.0.18-log
> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
> 
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
> 
> -- Dump completed on 2008-07-26 19:29:11
> sioux@robigo$
> 
> 
> As you can see, that's what happens.
> 
> Any suggestion?
> 
> On Sat, Jul 26, 2008 at 3:56 PM, Dan Nelson <dnelson@stripped> wrote:
> > 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
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

_________________________________________________________________
Time for vacation? WIN what you need- enter now!
http://www.gowindowslive.com/summergiveaway/?ocid=tag_jlyhm
Thread
mysqldumpJohn Nietzsche26 Jul
  • Re: mysqldumpDan Nelson26 Jul
    • Re: mysqldumpJohn Nietzsche26 Jul
      • RE: mysqldumpMartin Gainty27 Jul
      • RE: mysqldumpMary Bahrami28 Jul