Skip to content

IT Blog

Vyacheslav Gapon – personal blog, manuals, articles, notes, development

  • РусскийРусский

MySQL Error Solution: Can’t create table ‘tablename’ (errno: 150)

Posted byVyacheslav 23.01.202023.01.2020 Leave a comment on MySQL Error Solution: Can’t create table ‘tablename’ (errno: 150)

MySQL error: Can’t create table ‘tablename’ (errno: 150) can occur when you, for example, upload a backup and MySQL is powered to create table 1 which refers to table 2, which essentially does not exist yet. You can solve by inserting the lines at the beginning in the backup:

SET FOREIGN_KEY_CHECKS = 0;

And at the very end:

SET FOREIGN_KEY_CHECKS = 1;

See my other MySQL related articles

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Telegram (Opens in new window)
  • More
  • Click to share on Pocket (Opens in new window)
  • Click to share on Skype (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to print (Opens in new window)
Posted byVyacheslav23.01.202023.01.2020Posted inMySQL

Post navigation

Previous Post Previous post:
How to change user login in WordPress
Next Post Next post:
UBIQUITI (UBNT) OID’s & MIB’s

Leave a comment

Leave a Reply Cancel reply

Categories

Contacts
DONATE
About it
Privacy
Subscribe by Email (EN)
Подписаться по Email (RU)
YouTube
Instagram

При использовании материалов, активная ссылка на сайт ixnfo.com обязательна!
When using materials, an active link to ixnfo.com is required!

IT Blog © 2013-2023 Privacy Policy