Moodle lose some of the administrative privilege

You are playing with roles specially admin privilege or user privilege and you end up locking your self because of the wrong configuration. To restore it back to normal, you need to go to the database and find mdl_role_capabilities table and do a search for permission |= -1 and you will see the value of -1000. Just change the value to 1 for all the -1000.

Questionnaire Export CSV Issue

You're trying to export questionnaire responses to csv format and there are missing response on one or more columns. Check the question name for that missing column and rename it with something else. It's probably a general name such as ID or Full name that interfere with the moodle general field name.

Mysql trick show tables

mysql databasename -u [root] -p[password] -e 'show tables like "wp_153_%"' | grep -v Tables_in
| xargs mysqldump [databasename] -u [root] -p[password] > [target_file]