After importing "mysql dump" file test1.dmp file into database, the database does not show the tables relations

Question

Hi, I imported the mysql test1.dmp file into my "mysql database" using hte following command.

mysql> create database database_name;
mysql> use database_name;

In Linux command prompt, $ mysql -u user_name -p database_name < /tmp/test1.dmp

But, the newly created database_name does not show up the tables relations...It shows only the tables, but not relations.. I am looking this using

"phpmyamdin"

portal.

Is there any set up required before importing the database in mysql database..

Please let me know if any body know how to extract the relations between tables..

thanx,

Answer 1

Using mysqldump the relations between tables are not copied.
You have to do by hand.

If you copy a database in phpmyadmin, the relations stays.