Asqatasun v4 - Summary

Asqatasun v4 - Upgrade from Asqatasun v4.0.3 to v4.1.0

TL;DR

  1. Export data from host with v4.0.3
  2. Install on another host a fresh v4.1.0
  3. Import data from v4.0.3
  4. Update SQL schema
  5. Enjoy

1. Export data from v4.0.3

  1. Stop Apache
  2. Stop Tomcat
  3. Then export DB with
mysqldump \
  --user=asqatasun \
  -p \
  --databases asqatasun 
  --result-file=SAVE_DB_asqatasun.sql

2. Install Asqatasun v4.1.0

3. Import data from v4.0.3

mysql --user=asqatasun -p -e "drop database asqatasun;"
mysql --user=asqatasun -p <SAVE_DB_asqatasun.sql

4. Update SQL schema

Grab the two following file:

And apply the following (order in important):

mysql --user=asqatasun -p asqatasun <asqatasun-40-update-from-4.0.3-to-4.1.0.sql
mysql --user=asqatasun -p asqatasun <tgol-40-update-from-4.0.3-to-4.1.0.sql

5. Use Asqatasun 4.1.0