Howard Miller

I'm not sure what your question is (you don't seem to have asked one) but if it's "how do we organise our archived courses?" then you probably don't need anything more complicated than Course_categories and some administration effort.

If you want to make it more "interesting" then I know some sites do this kind of thing using multiple Moodle sites (a new year gets a new site). Which obviously adds all sorts of complexity but may make sense to large sites.

There's a few things that can go wrong. Make sure that the collation setting in Moodle's config.php is correct.

 

Also note that the "normal" collation for Moodle is utf8_unicode_ci (not just unicode_ci). 

I'm not very familiar with PHPMyAdmin but I'm sceptical that it will change the collation properly. It needs to do it for *every* text field in the database. Moodle has a command line tool for this...

php admin/cli/mysql_collation.php --collation=utf8mb4_unicode_ci

Try that

 

(You might need/want to read Administration_via_command_line)

I can't figure out what you're trying to do... but you're almost certainly doing it wrong. Can you explain in a bit more detail?

You should not be trying to sync on the internal user id number (I suspect).

These are the support forums for Moodle, not Softaculous. You'll need to ask Softaculous or your hosting company.

Even better - don't use Softaculous. There's really no need, and you won't run into issues like this.

I'm not entirely sure what you are asking... If you have files in the file table then they are, one would think, in use somewhere.

The best way to reduce files is to delete courses you no longer need or use.

Note that they way Moodle file cleaning works, it can take several days for them to completely go. Moosh has a handy tool to "purge" deleted files.