Used mysqldump for data only; Added 'set backslash_quote = on;' and 'set standard_conforming_strings = off;' in the header of the dump file. After that you need to create the PostgreSQL schema from OTRS scripts, import your data, run OTRS post database script and adjust sequences (you can generate the queries for that with py-mysql2pgsql and some scripting).
Solved the article_attachment with otrs.ArticleStorageSwitch.pl. Dropped files to filesystem, moved files to the new server and imported to database again. Thanks. On Thu, Mar 28, 2013 at 12:18 PM, Bogdan Iosif <bogdan.io...@gmail.com> wrote: > Does OTRS have a tool that you used to move the data? > > > On Thu, Mar 28, 2013 at 5:12 PM, aledr <matrixworkstat...@gmail.com> wrote: >> >> Good day! >> >> I'm moving my otrs installation from MySQL to PostgreSQL. >> Almost everything went fine, except article_attachment table. >> >> Is there any available instructions on how to move that data? >> >> Thanks. >> -- >> [ ]'s >> Aledr - Alexandre >> --------------------------------------------------------------------- >> OTRS mailing list: otrs - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/otrs >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs -- [ ]'s Aledr - Alexandre --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
