Transfer your Moodle Database from Postgres to Mariadb

Поділитися
Вставка
  • Опубліковано 3 лис 2024

КОМЕНТАРІ • 17

  • @irdi04
    @irdi04 6 місяців тому +2

    Thanks for this, it really helped a lot!

    • @Wise-Cat
      @Wise-Cat  6 місяців тому

      Thanks for watching. Glad it helped!

  • @sokcheapanha6134
    @sokcheapanha6134 Рік тому +1

    Nice video , Do have video for transfer database from gradebook to mysql server?

    • @Wise-Cat
      @Wise-Cat  Рік тому +1

      Sorry, I'm not exactly sure what you mean. Do you just want to export the gradebook SQL tables?

    • @sokcheapanha6134
      @sokcheapanha6134 Рік тому

      ​@@Wise-Cat yes , Can you tell me the process to export data from the gradebook to a MySQL server?

    • @Wise-Cat
      @Wise-Cat  Рік тому

      Ahh, I think I get what you mean now. However, unfortunately I think what you need will be very specific to your exact situation. If you're connecting Moodle to an outside system, the best advice I have is to use a connector app like Myddleware to get everything connected, www.myddleware.com
      Woah, BTW sorry for the late response. Just noticing now that I failed to follow up on this.

  • @christkant
    @christkant Рік тому +1

    Thanks a lot

  • @CesarMejía-z9z
    @CesarMejía-z9z Рік тому +1

    hi @WiseCat do you know a way to permanantly delete unlink files from moodledata repository? I have like 50GB os files that I positively know do not belong to anyuser but still we have. teacher files which are in use, so how too deal with them!? Thank you for the backup series, served me a lot!

    • @Wise-Cat
      @Wise-Cat  Рік тому

      I've never actually had the need to do this, so I don't know. My first instinct is to check all the recycle bin folders and make sure the scheduled tasks for clearing them are running properly. The strong medicine approach may be to backup the courses and rebuild the Moodle, though in that case, you should also try to diagnose why it is happening, so you can prevent it happening again. Sorry I can't be more help.

  • @snack753
    @snack753 4 місяці тому +1

    Thanks for all the moodle admin tutorials.
    I followed this one, however, I am stumbling about an error after changing the config.php.
    It shows
    Error: database driver problem detected
    The site administrator should verify server configuration
    Unknown driver native/
    Any idea what the problem is?

    • @Wise-Cat
      @Wise-Cat  4 місяці тому +1

      It looks like there is a typo in either the dbtype or dblibrary directives in config.php. Some common errors include not finishing the directive with a semicolon; having Capitalized some letters (MySQLi instead of mysqli); having the wrong dbtype (the most common being perhaps 'mysql' instead of 'mariadb'). If you can paste the first few lines of your config.php, that might help diagnosing the problem.

    • @snack753
      @snack753 4 місяці тому +1

      @@Wise-Cat Thanks for having a look into this.
      The first lines are:
      $CFG->dbtyle = 'mariadb';
      $CFG->dblibrary = 'native';
      $CFG->dbhost = 'localhost';
      $CFG->dbname = 'moodle';
      $CFG->dbuser = 'moodleuser';

    • @snack753
      @snack753 4 місяці тому +1

      @Wise-Cat ok ... found it: the typo is dbtyle instead of dbtype 🙈
      Thanks for your great videos and tutorials. You are one of my absolute favorites. informative and still entertaining.
      Please do never stop!

    • @Wise-Cat
      @Wise-Cat  4 місяці тому

      Ahh, well spotted. Glad to hear it all worked out.

  • @AndreiaRodrigues-z3k
    @AndreiaRodrigues-z3k Рік тому +1

    Hi @WiseCat, do you freelancer work? how can I connect with you?

    • @Wise-Cat
      @Wise-Cat  Рік тому

      Yes, I consult on various projects from time to time. You can contact me via email adam@wisecat.net