Posts made by Visvanath Ratnaweera

Moodle in English -> Installing and upgrading help -> Installing moodle in Bluehost -> Re: Installing moodle in Bluehost

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
> I managed to change collation of all the tables (including sum) to "utf8mb4_unicode_ci" but still I can't install moodle as it gives the same error.

That is odd. If you are going to install Moodle then the existing tables do not matter. In fact, there shouldn't be any tables. Run 'drop database DBNAME; create database DBNAME;' before you start to wipe out any old data.

> In phpMyAdmin the Server charset: UTF-8 Unicode (utf8). 

The following is from a MariaDB database working perfectly in Moodle 4.1 LTS:

> use db999;
Database changed
MariaDB [db999]> select @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4                  | utf8mb4_general_ci   |
+--------------------------+----------------------+
1 row in set (0.000 sec)
Average of ratings: -

Moodle in English -> General help -> Website Recovery -> Re: Website Recovery

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
I repeat:

- Whether a site could be restored from a database dump and the moodledata directory tree, fundamentally, Yes, if they were in sync as the backups were taken. The missing part, the Moodle code can be downloaded from moodle.org.
OK, when I say "can be done", I mean in a true Unix shell (CLI). Whether one can do it on the Cpanel at A2 hosting, that I don't know.


In other words, those two things, the database dump and the moodledata directory tree, or moodledata/filedir tree to be specific,
a) if they have them in their hands, any number of people in this forum can restore the site. 

b) I seriously doubt whether those jokers of supporters at A2 are able to do that.
Average of ratings: -