1. I’ve moved all attachments to FS using the script. 2. Run the CloneDB to move from MySQL to PostgreSQL. 3. After, moved all files from FS from one server to the new server
When I look to tickets, images and attachments are normal. When I look FAQ entries, no images are shown. Any tip? Atenciosamente, Edson Richter Soli Deo Gloria De: otrs <otrs-boun...@lists.otrs.org> Em nome de Edson Richter Enviada em: quinta-feira, 21 de fevereiro de 2019 00:01 Para: User questions and discussions about OTRS. <otrs@lists.otrs.org> Assunto: [otrs] RES: OTRS 5 migration from MySQL to PostgreSQL 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<mailto: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<mailto: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://nam03.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%7Cd698e1c9f91c4f818a6c08d697a8efb9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636863149167630842&sdata=M5UakxHNZnhEO%2FeLeaAy%2BQzIQGytfOGcAB89%2BbFAJ7c%3D&reserved=0> -Never Edson Richter <edsonrich...@hotmail.com<mailto: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://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fotrs.org%2F&data=02%7C01%7C%7Cd698e1c9f91c4f818a6c08d697a8efb9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636863149167650859&sdata=w4mfqDh%2BykBn4V8EyGQPZo9TDg84Hbde2zl%2BdmrwGk0%3D&reserved=0> Archive: http://lists.otrs.org/pipermail/otrs<https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&data=02%7C01%7C%7Cd698e1c9f91c4f818a6c08d697a8efb9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636863149167660876&sdata=qMDSS7cU62FWJvVZb8xyB8gDxPMocW1T%2FxbDoTS15co%3D&reserved=0> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs<https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&data=02%7C01%7C%7Cd698e1c9f91c4f818a6c08d697a8efb9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636863149167670887&sdata=P9h8ZEN9K07ywO9qG9DE%2Bsek3442ymhvZBE0xWMU3nA%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
