2014-09-21, 05:24 PM
I have a forum I originally installed with pgsql (don't ask why). I wish to move it to mysql prior to upgrading it to 1.8 (it's at 1.6.13 now), as i've had numerous odd bugs with regards to installing plugins (guid never gets set right) and I'm tired of dealing with that.
The database EXPORTS from the mybb database backups DO NOT LOAD in phpmyadmin complaining about
syntax errors, unexpected charactors and other problems.
I've also tried installing a new instance of mybb (same version) then considering trying to do a table by table export/import, but for 71 tables that's a lot of work, and considering the previous troubles its still going to choke..
Has ANYONE successfully changed DB engines via export/import or some conversion tools?
What tables need to be brought across to get the users, all forums/subforums/topics and posts?
What tables are considered "non-essential" meaning I can reset those options from the Gui.
The database EXPORTS from the mybb database backups DO NOT LOAD in phpmyadmin complaining about
syntax errors, unexpected charactors and other problems.
I've also tried installing a new instance of mybb (same version) then considering trying to do a table by table export/import, but for 71 tables that's a lot of work, and considering the previous troubles its still going to choke..
Has ANYONE successfully changed DB engines via export/import or some conversion tools?
What tables need to be brought across to get the users, all forums/subforums/topics and posts?
What tables are considered "non-essential" meaning I can reset those options from the Gui.