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/