Sunday, October 30, 2016

Export Bugzilla and reimport/move to new server?



I've created a new VM to host our outdated Bugzilla server and now I need to move the database over to the new VM.



Our old server is running Bugzilla 2.16.3, which I plan on using on the VM as well. This is just to get it off the old hardware. I don't want to mess with VM Converter for something like this.




So my question is:




  1. How can I export/reimport the Bugzilla database and settings?

  2. Anything else I need to setup, understand before I do this?



I'm not a Linux expert either, so forgive me. I'll be using Fedora 9 to host Bugzilla with.


Answer




Things you must take care of:




  • Web server setup. Apache + mod_perl most likely.

  • Exporting SQL dump and importing it to a new server.



export for mysql:



mysqldump --force --opt --user=$USER --password=$PASSWORD --databases $db > bugzilla.sql




import for mysql:



mysql -u $USER -p < bugzilla.sql




  • Install missing PERL CPAN modules



Run ./checksetup.pl in bugzilla directory to get a report on what's missing. It'll also show you the lines needed for installation. If installing via perl directly fails (which often does), try using your local disto package manager to install missing stuff (yum on Fedora I take it?)





  • Point your browser to the new installation and debug further issues.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...