The innodb storage engine supports foreign keys in Mysql. To create foreign keys in phpmyadmin : 1. Convert both tables into innodb, if they are not already. 2. View the structure of the table which will have a foreign key. Make the referencing field an INDEX. 3. Now come back to structure view and click Relation view. In the Relation view page the field (which was made an INDEX) can be made a foreign key [...]

A little back I tried to backup a database from my webhost and restored it on my localhost mysql. It had a few views. On accessing the views in phpmyadmin mysql gave the error : #1449 – There is no ‘projects’@’localhost’ registered #1449 – There is no ‘projects’@’localhost’ registered So I opened the dump file and found that the error was being caused by a line which looks like this : /*!50013 DEFINER=`projects`@`localhost` SQL SECURITY [...]