- Denish Patel
- 14th December 2011
- mysql
Have you ever come across this error?
MySQL Error Number 1005
ERROR 1005 (HY000): Can’t create table ‘./wordpress/#sql-2693_f74e.frm’ (errno: 150)
Jason summarized very good article to track down error reported on his blog.
It helped me , hopefully these tricks will help you as well!!
Post in comment , if it helps to save your day!!
Join the conversation
Leave a comment
Leave a comment
Categories
Recent Blog
- Do you really need a DBA?
- Running VACUUM FULL in Non-blocking Mode
- Connection Scaling
- PSQL Helper: Managing Connections and Simplifying Queries
- Vacuum Those MVs!
- Working With Repmgr: Using Other 3rd Party Tools for Setting up a Standby
- Working with Amazon Aurora PostgreSQL: dag, standby rebooted again!
- Working with Amazon Aurora PostgreSQL: what happened to the stats?
- How to set application_name for psql command line utility?
- Is there a limit on number of partitions handled by Postgres?
You can find all that information on the MySQL manual page: http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
Sheeri,Thanks for pointing that out. The problem is ERROR is misleading and it takes long time to reach to that page instead you reach to ERROR page and you will be misguided. I think MySQL ERROR doc should link http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html .