Tag Archives: phpmyadmin

Fixing SQL errno: 150

Description: On table altering, SQL or phpMyAdmin throws an 150 error, with a message like “Error on rename of ‘./tables/#sql-efc_1’ to ‘./tables/my_table’ (errno: 150)” or “Cannot add or update a child row: a foreign key constraint fails”. Solution: Error 150 is related … Continue reading

Posted in Best practices, SQL | Tagged , , , | 2 Comments

Increase phpMyAdmin file import size

Description: phpMyAdmin allows by default a maximum upload size of 8Mb for importing a sql file.This can be sometimes too small. Solution: The maximum import size is stored in the php.ini file located in the PHP directory. Look for the … Continue reading

Posted in System | Tagged , , , | Leave a comment