Loading mysql Dumps

Not really a Django-specific topic but highly useful all the same.

To circumvent Foreign Key relationship restrictions you can do this:

mysql> SET foreign_key_checks = 0;
mysql> SOURCE /some/directory/my_big_dump.sql;
mysql> SET foreign_key_checks = 1;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s