Tried to import a mysql innodb from a sql dump file, but it keep show me there is an foreign key constraint error. Due to innodb has foreign key check validation, it does not allow me to continue n show me foreign key constraint error. Ya! I know my data having some foreign key constraint problem, but what i need to do now is to import my sql dump file!
Here’s the error message “#1452 – Cannot add or update a child row: a foreign key constraint fails…”
After going thru the mysql documentation, finally i found the solution! This solution not only allow me to import my innodb, but also improve the import speed tremendously!
To import mysql innodb with foreign key constraint error, follow the steps below:-
Continue reading How to import mysql innodb with foreign key constraint error? »
It’s good to hide the apache2 version number from outsider. Especially hiding apache2 version number in all the error pages. Hackers used to collect all this information before they launch any attack. If you running an old version server that known to have security exploit then it will ease the work for hackers.
I’ve many email account in my Thunderbird and I’ve been facing the problem of how to rearrange the account order in Thunderbird. By default, Thunderbird will arrange the account based on the time you create the email account (latest account will be arrange at bottom). 