[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]
