Re: Migrating Bugzilla between different time zones - problem

glauber ribeiro <[email protected]>
Newsgroups gmane.comp.mozilla.devel.webtools
Message-ID <[email protected]>
On Wednesday, September 30, 2020 at 4:42:16 PM UTC-5, Thorsten Schöning wrote:
> Guten Tag glauber ribeiro, 
> am Mittwoch, 30. September 2020 um 23:08 schrieben Sie:
> > All this stuff is reminding me why i have never become a MySQL fan.
> My last suggestion for today is maybe things work better with 
> PostgreSQL for you: 
> 
> https://www.bugzilla.org/docs/4.4/en/html/api/contrib/bzdbcopy.html 
> 
> I recently switched myself for other reasons, might be worth a try if 
> you have easy access to a Postgres-installation.
> Mit freundlichen Grüßen, 


Hmmm, yes, this could well be "the nuclear option".

So i would make a copy of my Bugzilla directory, then in the copy edit localconfig to point to an empty Postgres database, and run checksetup,pl to create the database structures. Then this script would copy from the MySQL to the Postgres. Both databases need to be accessible to the script at the same time.

Is the above paragraph correct?

Thanks,

g
_______________________________________________
support-bugzilla mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [email protected] in the To: field when you reply.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.