List:General Discussion« Previous MessageNext Message »
From:John Nietzsche Date:July 26 2008 7:30pm
Subject:Re: mysqldump
View as plain text  
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
>
>
Thread
mysqldumpJohn Nietzsche26 Jul
  • Re: mysqldumpDan Nelson26 Jul
    • Re: mysqldumpJohn Nietzsche26 Jul
      • RE: mysqldumpMartin Gainty27 Jul
      • RE: mysqldumpMary Bahrami28 Jul