Export sql file from phpmyadmin

Use the below to set the session foreign key checks to 0 temporarily.

mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u root -p landstack < landstack.sql

Then log into your mysql and run the following to set the checks to back on:

SET FOREIGN_KEY_CHECKS=1;

Or

You can replace the first command with

mysql -u root -p landstack < landstack.sql

and do a custom export for phpmyadmin with the 'Disable Foreign Keys' button selected.

This is necessary otherwise you may receive a foreign key constraint error when importing the database.