How to disable or remove foreign key before importing database to phpmyadmin?

Question

We can import any heavy database into phpmyadmin from command prompt. But many tables have foreign key and it is not allowed to insert a table having foreign key. So how to remove or disable foreign key in order to import database in phpmyadmin?

Answer 1

Ya, we can set foreign key check as disable before importing database into phpmyadmin.

What we need to do is, edit that database file i.e. yourdatabase.sql and add 2 lines in it.

1) Add in just beginning of database file

SET FOREIGN_KEY_CHECKS = 0;

2) Just before end of file at last line of file.

SET FOREIGN_KEY_CHECKS = 1;

First it will disable foreign key checks and in the end, it will enable it again.

Answer 2

GO to export in in phpmyadmin follow below step.

Answer 3

You can also set it from the commandline directly into the mysql command.

mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" ...