mysql

mysql internal relation not working when i export to anther database

hi im using mysql database everything working so good so far .. and i have internal relations like this picture .. enter image description here

but if i export the databsae and import it on new database the internal relations gone like this picture .. enter image description here

so how can i export the database with internal relations .. thanks ..

Solution

  • I believe internal relationships are used for the DB Designer, in order to visually draw links between your tables keys. The only way to export those relationships from PhpMyAdmin DB Designer is via PDF, so it is not aimed at importing the structure in another instance.

    If you need to have PRIMARY keys and FOREIGN keys, you need to integrate them in your CREATE TABLE directives, like so:

    CREATE TABLE accounts (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    account_menu_detale_main_account_id INT UNSIGNED NOT NULL,
    PRIMARY KEY(id),
    FOREIGN KEY(account_menu_detale_main_account_id) REFERENCES accounts(id)
);