John, Cut out the sql that creates and loads the problem table and run it by itself to capture the error messages as it loads; I don't know how you're loading, but in mysql, you could do : tee myload.out; source tableload.sql; notee;
Then check myload.out for the errors....I had problems with loading 4.1 to 5.1 due to the change in defaults for timestamps between the versions, just corrected the table create sql and it loaded fine. mary -----Original Message----- From: John Nietzsche [mailto:[EMAIL PROTECTED] Sent: Saturday, July 26, 2008 12:31 PM To: Dan Nelson Cc: mysql@lists.mysql.com Subject: Re: mysqldump [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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
