You are here: Portal Home > Knowledgebase > Databases > MySQL errno: 150
Please Login

MySQL errno: 150

 

If you’re trying to import an sql file and you get this error :

ERROR 1005 (HY000): Can't create table 'Table.frm' (errno: 150)

then add these commands at the top and bottom of the sql file:

Top of dump file:

SET FOREIGN_KEY_CHECKS = 0; -- TOP 

 

Bottom of dump file add:

SET FOREIGN_KEY_CHECKS = 1; -- BOTTOM 

 



Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Also Read

Client Login

best hosting
Remember Me  

Search

uk web hosting

managed server
 
All Content © 2000-2012 Fast2host Limited. All Rights Reserved.
UK Company Registration Number: 05348700VAT Number: GB 884 9830 61 — BGP4 Network AS48825

Fast2host provides the best in hosting. Should you find that our services do not meet your specifications, we offer a full refund, providing your service cancellation is made within 30 days of opening your account. (The 30 day guarantee applies to Shared Hosting Solutions, for other solution guarantees please see 30 Day Money Back Guarantee.)

With the latest cloud VPS technology and infrastructure located in the UK, within our own datacenter, we can help your business thrive on the internet. Fast2host can setup and host sites whatever your hosting needs. Whether you're just establishing a presence on the internet, or you want to manage, maintain and monitor an eBusiness web hosting solution, we can help.

This is what makes Fast2host different, we provide a unique web hosting service for each client, including adult web hosting, providing close contact and support to create 100% satisfaction. We are here to help and support you throughout.

A dedicated server can be rebooted remotely. Cloud vps hosting allows you to reinstall OS instantly. Cpanel hosting you can restore files yourself. 100% White Label Reselling hosting you can make money today.