On 05/15/10 17:22, Egbert Jan wrote: > Hi, also asked this om the forum. > > I'm in a situation where I need to pre-load (prime) the database tables with > correct data. Getting the data ready for loading isn't the problem, I do > this all the time with the postfixadmin tables. A bit of perl and some copy > ans pasting fits the job. The roundcube tables, however, are cleverly linked > with foreign keys which prevents me to just delete a table and re-generating > an filling it with my own data. Unnessessary to say that > ['auto_create_user'] = FALSE here. > > Is there anybody out there who could put me om the right trace? I realize > that this is more a MySQL question but I thought trying it here first.
Just turn off the foreign key checks while you're importing data: SET foreign_key_checks = 0; Reference: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html Search for foreign_key_checks. _______________________________________________ List info: http://lists.roundcube.net/users/
