Transfer your Moodle Database from Postgres to Mariadb

Transfer your Moodle Database from Postgres to Mariadb or the other way using the dbtransfer tool.
Though MySQL and Mariadb are drop-in replacements for each other, switching to other SQL flavours is a little bit more complicated. Fortunately, Moodle includes a tool that takes the pain out of switching.
In this video, I transfer a Moodle DB from Postgres to Mariadb and then back to a different Postgres database.
Happy Moodling!

[@irdi04]

Thanks for this, it really helped a lot!

[@Wise-Cat]

Thanks for watching. Glad it helped!

[@sokcheapanha6134]

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

[@Wise-Cat]

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

[@sokcheapanha6134]

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

[@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]

Thanks a lot

[@Wise-Cat]

Happy to help

[@snack753]

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]

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]

@@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]

@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]

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

[@user-un6bj7pc7q]

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

[@Wise-Cat]

Yes, I consult on various projects from time to time. You can contact me via email [e-mail]

[@user-vq8kr8yt6t]

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]

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.