Table does not show table relationships after importing database

Question

I imported the MySQL dump file to my MySQL server using the following command.

mysql> create database database_name;
mysql> use database_name;

Linux command line

$ mysql -u user_name -p database_name < /tmp/test1.dmp

But when viewing the database using the phyMyAdminnewly created database_name does not display the table relationship. It shows only tables, but not relationships.

Is there any configuration required before importing the database into the mysql database?

How to extract relationships between tables?

Answer 1

I just looked at the same issue.

Is there any configuration required before importing the database into the mysql database?

, , LAMP Server Ubuntu, Linux MyISAM . InnoDB . ^[]

. [ ]

default-storage-engine = InnoDB [mysqld] mysql (my.cnf my.ini ) mysqld. , phpMyAdmin.

ubuntu my.cnf /etc/mysql/.

mysql

mysql > SET storage_engine = InnoDb;

, , InnoDB , .

?

, . , . ,

ALTER TABLE <table_name> ENGINE = innodb

phpMyAdmin

• [. ]
• 
• InnoDb Go

phpMyAdmin mysqldump. .

Answer 2

mysqldump .
.

phpmyadmin, .