From Foochal

Contents 1 Move the bugzilla directory 2 Install perl modules 3 Move the database 3.1 On your old host 3.2 On your new host 3.2.1 For mysql 3.2.2 For postgres 4 Copy apache httpd.conf settings 5 DNS changes

Move the bugzilla directory

Use scp or rsync to copy the old mediawiki directory to the new host.

scp -r root@oldhost:/usr/local/bugzilla /usr/local

Install perl modules

http://www.bugzilla.org/docs/2.22/html/installation.html#install-perlmodules

Move the database

On your old host

• Backup the database on your old host

For mysql:

mysqldump mediawiki_dbname > mediawiki_backup.sql

For postgres:

• Transfer the backup file, via scp or rsync to the new host

On your new host

• Create the bugzilla user on your new host. You can find the wiki user name and password in the bugzilla localconfig file.

For mysql

create database bugs;
GRANT ALL PRIVILEGES ON *.* TO 'bugs'@'localhost' IDENTIFIED BY 'bugs_password' WITH GRANT OPTION;
mysql --user root -p -h localhost bugs < bugs_backup.sql

For postgres

createuser -P bugs
Enter password for new user:
Enter it again:
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n

Allow postgres users 'bugs' to connect to the 'bugs' database

vi /var/lib/pgsql/data/hba.conf

Add the following line:

# allow '127.0.0.1' to 'all' databases on this server from the 'bugs' user, and use md5 auth
host    bugs         bugs        127.0.0.1 255.255.255.255 md5

Restore db: psql -h localhost -U bugs bugs -f mydb.sql

Copy apache httpd.conf settings

1. If you are using a virtual server for your bugzilla installation, copy the relevant lines from your apache httpd.conf file to your apache on your new host.
2. Restart apache

DNS changes

Change any DNS entries to make them point to your new bugzilla server. DNS changes usually take at least a few hours to propagate and you might want to disable your bugzilla via your old apache config and start redirecting to the new host in the meantime.