Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.
Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca
This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
I'd like to migrate a MySQL database (with a lot of articles) to a PostgreSQL database. There's any tool to do such migration? Or just a SQL dump/import will work fine?
- Posts: 1
- Joined: Mon Jul 09, 2007 11:40 pm
There are a number of compatibility options that the mysqldump tool accepts; some combination of these should be PostgreSQL-compatible. You may need to fine-tune a few pieces of the SQL dump (e.g. column types / indexes), but I don't expect it will be complicated.
Public Knowledge Project Team
- Posts: 10015
- Joined: Wed Aug 10, 2005 12:56 pm
Return to OJS Technical Support
Who is online
Users browsing this forum: No registered users and 1 guest