Converting from Postgres to MySQL

Converting from Postgres to MySQL

by Jason Cole -
Number of replies: 2
Hey all,

We're about to roll out a production server for 23 courses for the fall and into the spring. I'm currently running Postgres, but I'm getting a lot of log and backup errors. So I want to switch over to MySQL.

Anyone have an easy way to move the data from pg to mysql? I thought I saw something here a while back but I can't seem to find it now.

TIA

J
Average of ratings: -
In reply to Jason Cole

Re: Converting from Postgres to MySQL

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I've never done it but just a thought....

Will doing a backup from the PostgreSQL based system and then restoring on the MySQL system not do the job?

Weirdly there seems to be a number of utilities to go from mysql to postgres but not the other way,
In reply to Howard Miller

Re: Converting from Postgres to MySQL

by Jason Cole -
I can't do a system wide backup as I get db errors. I'll have to back up each course seperately.