[Flow] Importing data to another database

[Aske Ertmann]

Hey Stephen,

You can disable foreign key checks for you database while you do the import, however this is a workaround for something that sounds broken.

SET foreign_key_checks = 0; sets it for the session, while SET GLOBAL foreign_key_checks = 0; sets it for all sessions.

Hope that helps.

Cheers,
Aske

On 14 Sep 2014, at 09:16, Stephen Bungert <stephenbungert at yahoo.de> wrote:

> Hello.
> 
> I have a test site with a database containing data from a flow application. I tried then exporting the database and importing it to a new database but keep getting errors about foreign key constraints failing.
> 
> How can i import everything in a database without getting all these errors?
> 
> Thanks for any help.
> 
> Stephen.
> _______________________________________________
> Flow mailing list
> Flow at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow