From: Martin Gainty
Date: July 27 2008 1:07am
Subject: RE: mysqldump
List-Archive: http://lists.mysql.com/mysql/213870
Message-Id: <BLU142-W34A5FD556A1F20447058F6AE800@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_36266374-aa20-4137-8078-83d599f1289e_"

--_36266374-aa20-4137-8078-83d599f1289e_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


John and Dan-

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

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


> Date: Sat=2C 26 Jul 2008 16:30:55 -0300
> From: john.nietzsche@stripped
> To: dnelson@stripped
> Subject: Re: mysqldump
> CC: mysql@stripped
>=20
> 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=3D@@TIME_ZONE */=3B
> /*!40103 SET TIME_ZONE=3D'+00:00' */=3B
> /*!40014 SET @OLD_UNIQUE_CHECKS=3D@@UNIQUE_CHECKS=2C UNIQUE_CHECKS=3D0 */=
=3B
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=3D@@FOREIGN_KEY_CHECKS=2C
> FOREIGN_KEY_CHECKS=3D0 */=3B
> /*!40101 SET @OLD_SQL_MODE=3D@@SQL_MODE=2C SQL_MODE=3D'NO_AUTO_VALUE_ON_Z=
ERO' */=3B
> /*!40111 SET @OLD_SQL_NOTES=3D@@SQL_NOTES=2C SQL_NOTES=3D0 */=3B
> /*!40103 SET TIME_ZONE=3D@OLD_TIME_ZONE */=3B
>=20
> /*!40101 SET SQL_MODE=3D@OLD_SQL_MODE */=3B
> /*!40014 SET FOREIGN_KEY_CHECKS=3D@OLD_FOREIGN_KEY_CHECKS */=3B
> /*!40014 SET UNIQUE_CHECKS=3D@OLD_UNIQUE_CHECKS */=3B
> /*!40111 SET SQL_NOTES=3D@OLD_SQL_NOTES */=3B
>=20
> -- Dump completed on 2008-07-26 19:29:11
> sioux@robigo$
>=20
>=20
> As you can see=2C that's what happens.
>=20
> Any suggestion?
>=20
> On Sat=2C Jul 26=2C 2008 at 3:56 PM=2C Dan Nelson <dnelson@stripped=
m> wrote:
> > In the last episode (Jul 26)=2C 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=2C 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=2C but when i try to restore (s.sql) in the server i=
=2C
> >> mysql (client utility) complains on error and exit=2C 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=2C 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=3Djohn.nietzsche@=
gmail.com
> >
> >
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Time for vacation? WIN what you need- enter now!
http://www.gowindowslive.com/summergiveaway/?ocid=3Dtag_jlyhm=

--_36266374-aa20-4137-8078-83d599f1289e_--