Moving dotproject to a new Ubuntu Server

This morning I had to do a test move of our newly updated dotproject install from our old Ubuntu 10.04 vm to a newly installed Ubuntu 14.04 vm.

The process I used was as follows:

On the old server I used mysql dump to backup the database:

#mysqldump -u [USERNAME] -p[PASSWORD] [DATABASE-NAME] > dumpfilename.sql

The resulting dumpfile was copied to the new server.

The /var/www/htlm/dotproject folder was moved to /var/www/html/ on the new server.

The instructions on THIS site were used to create the new database and change the folder permissions of the new /var/www/html/dotproject

The required apps were installed:

#sudo aptitude install mysql-server mysql-client php5 php5-mysql unzip libphp-jpgraph libgd-tools

#sudo apt-get install php5-gd php5-ldap

The database was created:

#mysql -u root -p -e "create database dotproject;"

Access was given to the dotproject user:

#mysql -u root -p -e "grant all privileges on dotproject.* to dotproject@localhost identified by 'SUA_SENHA';"

The correct folder permissions were set:

#sudo chown www-data.www-data /var/www/dotproject -Rf && sudo chmod 755 /var/www/dotproject -Rf

Acesse o arquivo php.ini
sudo vim /etc/php5/apache2/php.ini
Localize a linha abaixo
; Initialize session on request startup.
session.auto_start = 0
Substitua o 0 por 1
; Initialize session on request startup.
session.auto_start = 1
Reinicie o Apache2
sudo apache2ctl restart

The sql dump from the old server was then imported into the newly created database:

#mysql -u username -p database_name < dumpfilename.sql

Dotproject is now running on the new server.