MySQL

• Restore the database from the backup/backup_mysql.tgz, or use six for migration. The MySQL user is root.
• Table schema are defined by src/models.py. The database is named primerize, with these tables:
  • auth_group, auth_group_permissions, auth_message, auth_permission, auth_user, auth_user_groups, auth_user_user_permissions
  • django_admin_log, django_content_type, django_flatpage, django_flatpage_sites, django_migrations, django_session, django_site
  • src_design1d, src_design2d, src_design3d, src_historyitem, src_jobgroups, src_jobids, src_sourcedownloader
• The demo entries are stored with date as 1970-01-01 on purpose. They will not be cleanup. So are their JOB_ID in the src_jobids table.
• Configuration file is located at /etc/mysql/my.cnf. MySQL version 5.7 is known to be memory-hungry, with all limits enforced, still gradually increase its memory usage to above 700 MB. Thus, we have downgraded to version 5.6. (Solved now by MySQL 5.7.13+.)