Backup semester data - UQ-eLIPSE/shifoo-docs GitHub Wiki

uqpwalle@mango:/home/groups/shifoo$ ls -l
total 109
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:49 2019s01 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:49 2019s02 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:49 2019sum -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:48 2020s01 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:48 2020s02 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:49 2020sum -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:47 2021s01 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:47 2021s02 -> 2022s01
lrwxrwxrwx 1 uqpwalle shifoo   7 Nov 24 17:48 2021sum -> 2022s01
drwxrws--- 2 uqpwalle shifoo   6 Nov 24 17:51 2022s01
drwxrws--- 2 uqpwalle shifoo   5 Nov 24 17:30 2022s02
drwxrws--- 2 uqpwalle shifoo   4 Nov 24 16:27 2022sum
drwxrwsr-x 2 uqrtho17 shifoo  10 Nov 24 16:27 2023s01
drwxrws--- 2 uqpwalle shifoo  11 Nov 11 12:21 2023s02
-rw-rw-r-- 1 uqpwalle shifoo 423 Aug  3 18:48 META.md

select
	x.ctx, count(*) active_user_count, sum(x.count) attempt_count
from (
	select c.context_id ctx, u.id uid, count(*) count
	from course c
	join user u on (c.id = u.course_id)
	join attempt a on (u.id = a.user_id)
	group by 1,2
) x
group by 1;
root@shifoo-000:~# mysql -uroot -p$(mdata-get mysql_pw) shifoo -e '<query_above>' > <course_id>_courses.md 

root@shifoo-000:~# mysqldump -uroot -p$(mdata-get mysql_pw) shifoo > shifoo_####.sql

uqpwalle@mango:/home/groups/shifoo/2022s02$ scp shifoo-000:~/shifoo_7260.sql .
uqpwalle@mango:/home/groups/shifoo/2022s02$ scp shifoo-000:~/7260_courses.md .
uqpwalle@mango:/home/groups/shifoo/2022s02$ ls -1
7260_courses.md
mypythontutor_7260.sql
shifoo_7260.sql