> > Also, would be nice to add a suggestion for large installations to put all > attachments on filesystem first >
nice, thank you for your share -Never Edson Richter <edsonrich...@hotmail.com> 于2019年2月21日周四 上午11:01写道： > Thank you very much. It is wonderful how easy this script made my day. > > The only think I’ll point is that documentation is far behind the PDF that > you have access through the web interface. > > Also, would be nice to add a suggestion for large installations to put all > attachments on filesystem first – a “dry-run” will just die with 19Gb of > attachments in mysql database (and I suspect that a migration also will > die). > > > > > > Atenciosamente, > > > > Edson Richter > > > > > > > > Soli Deo Gloria > > > > *De:* otrs <otrs-boun...@lists.otrs.org> *Em nome de * Never Min > *Enviada em:* quarta-feira, 20 de fevereiro de 2019 07:08 > *Para:* User questions and discussions about OTRS. <otrs@lists.otrs.org> > *Assunto:* Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL > > > > Hi, > > > > please see this link: > > > https://doc.otrs.com/doc/manual/admin/5.0/en/html/installation-on-windows.html > <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.otrs.com%2Fdoc%2Fmanual%2Fadmin%2F5.0%2Fen%2Fhtml%2Finstallation-on-windows.html&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051950398&sdata=GwZqUKW8SiqUu0B%2FXf%2FPc6he96weOVQFi9owensGySI%3D&reserved=0> > > > > > > -Never > > > > > > Edson Richter <edsonrich...@hotmail.com> 于2019年2月20日周三 上午6:13写道： > > Our company uses PostgreSQL as standard database for everything (that > needs one 😉 ). > > So, our OTRS 5 system is the last one based on MySQL. Since we are facing > some OS update issues, we decided it is time to move. > > I would like to know if there is a easy way to migrate data: for instance, > can I bakcup (using otrs backup/restore scripts) on MySQL and restore on > PostgreSQL? > > Or can you point me the tables that are more critical? > > I’ve tried to migrate using pgLoader (it is a breeze), but some contente > show strange caracters after migration. > > > > I’ll appreciate your guidance or share your experience! > > > > > > > > Atenciosamente, > > > > Edson Richter > > > > > > > > Soli Deo Gloria > > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fotrs.org%2F&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051960409&sdata=S0Zrt%2FAyYYYuafAz8%2BX769GK4S0wNu7r%2BPPjGo7XNAQ%3D&reserved=0> > Archive: http://lists.otrs.org/pipermail/otrs > <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051970414&sdata=fBG6R%2Fmcxa%2F09sYxkWlqZk%2FVzdzteCL2PRr9poR%2F7c4%3D&reserved=0> > To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs > <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051980426&sdata=ksnwWDOlr0Bj2h3IyAyWoXnpxW%2BHsI6vIueip4VXYFQ%3D&reserved=0> > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
