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: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: mysqldump > CC: mysql@lists.mysql.com > > [EMAIL PROTECTED] 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 [EMAIL PROTECTED] */; > > /*!40101 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40111 SET [EMAIL PROTECTED] */; > > -- Dump completed on 2008-07-26 19:29:11 > [EMAIL PROTECTED] > > > As you can see, that's what happens. > > Any suggestion? > > On Sat, Jul 26, 2008 at 3:56 PM, Dan Nelson <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > -- > > 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] > _________________________________________________________________ Time for vacation? WIN what you need- enter now! http://www.gowindowslive.com/summergiveaway/?ocid=tag_jlyhm