Django dump & restore database

Submitted by benl on Tue, 05/17/2011 - 09:39
Related Terms :

# dump data to send to receiving host
./manage.py dumpdata > fixtures/all.json

# in mysql on receiving host
mysql -uUSER -pPASS DATABASE_NAME;
drop database DATABASE_NAME;
create database DATABASE_NAME;
exit;

# @ shell on receiving host
./manage.py syncdb

# in mysql on receiving host
mysql -uUSER -pPASS DATABASE_NAME;
delete from auth_permission; delete from django_admin_log; delete from django_content_type;

# @ shell on receiving host
./manage.py loaddata fixtures/all.json