Tag Archives: mysql

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

MySQL database import using Command Line under Windows

Description: Import larger databases can cause timeouts or errors in phpMyAdmin. For this situations we need to use the command line import. Solution: The file we need is mysql.exe situated in the xampp directory under \xampp\mysql\bin\ . Then 2 steps are … Continue reading

Posted in SQL | Tagged , , | Leave a comment