Database in path to foreign key references

[Christian Lizell]

Hello!

Is there any way to get rid of the database name in the path to the reference of a foreign key. When using mysqldump to copy a database the name of the source database is in the path of the foreign key reference. In my case, that is not what I want.

An example:

mysql> use source_database;
mysql> create table T (
myId int not null, KEY id_ind (myId),
FOREIGN KEY (myId) REFERENCES T2 (otherId)
) type=innodb;

bash> mysqldump source_database
CREATE TABLE T (
myId int(11) NOT NULL default '0',
KEY id_ind (myId),
FOREIGN KEY (`myId`) REFERENCES `source_database.T2` (`otherId`)
) TYPE=InnoDB;

bash> mysqldump source_database | mysql destination_database

Now I have a working copy of the source_database, however all references are to the source_database, which is really not what I want.

Is this a feature or is it a bug? Is there a way to get mysql not to add the database name in the foreign key reference?

Thanks,
/Christian

--
__ Athega AB _____________________ for net workers __
Hantverkargatan 21 phone +46 8 54513330
SE-112 21 Stockholm, SWEDEN fax +46 8 54513338
http://www.athega.se/ mobile +46 709 156000


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php