MySQL

Richard's picture

MySQL: Disable foreign keys while updating database

Posted Sat, 01/30/2010 - 08:51 by Richard

Originally found here: http://www.stetsenko.net/2008/10/mysql-how-to-ignore-checking-of-foreign-key-constraints-for-innodb-tables/

Making a note of it here because it always take me a while to find the above article.

You can switch off checking of foreign keys while you truncate/populate the tables in a MySQL database with: 

SET FOREIGN_KEY_CHECKS = 0;

and re-enable it with:

Richard's picture

OldMasterFlash.com

Posted Sun, 03/29/2009 - 10:09 by Richard
OldMasterFlash.com
URL: 
OldMasterFlash.com
Employer: 
Futurate Ltd.

This site was put together to showcase a few 'web 2.0' community features for prospective clients, and for a bit of fun :-)

It also gave us an opportunity to learn how to integrate a flash application with a CakePHP back-end and was my first introduction to the PHP GD library.

It's still a work in progress but is already proving very popular. 

Richard's picture

Plymgo.com

Posted Sat, 03/28/2009 - 16:10 by Richard
Plymgo.com
URL: 
Plymgo.com
Employer: 
Futurate Ltd.

Another CakePHP website. Incorporates a number of 3rd party services (Google Maps, BBC Weather, a public transport route planner, US Geological Survey) to provide a public transport portal for the Plymouth Area.

Syndicate content