This article talks about upgrading Parallels Plesk Billing 5.0.5 and higher to the latest version. NOTE: If your Parallels Plesk Billing is 5.0.4 and older, contact our support team regarding the update.
It is highly recommended that you have Shell access to your server in order to update Parallels Plesk Billing. Thus, you have full control over the settings in your environment and your sensitive customer data is kept separate from other sites.
Backing Up Database
Before updating Parallels Plesk Billing, create a backup of all data (both fileset and database). If you installed the product to the "
plesk-billing" directory, the directory structure will be "
plesk-billing/lib-billing" and so on.
- Move your fileset to a new location to back it up:
# mv plesk-billing plesk-billing.bak
- To find your MySQL username and password to access your database, go to the
config.phpfile from your existing installation and run:
# cat plesk-billing.bak/lib-billing/include/config/config.php | grep db
You will see user MySQL data on your screen:
$CONF["dbType"] = "mysql";
$CONF["dbHost"] = "localhost";
$CONF["dbName"] = "dbname";(you should see your own MySQL DB name)
$CONF["dbUser"] = "dbuser";(you should see your own MySQL username)
$CONF["dbPass"] = "password";(you should see your own MySQL password)
- Using this information, create a backup copy of the database with the following command:
Note: Make sure that the character set is UTF-8. To do that, use the argument
# mysqldump --default-character-set=utf8 -u'dbuser' -p'password' -h'localhost' dbname | gzip > dbname_backup.sql.gz
where dbname_backup.sql.gz file is the database backup copy.
To update Parallels Plesk Billing via SSH access:
- Go to the web-accessible folder on your server:
- Download the latest Parallels Plesk Billing Standalone 6.0 fileset in your encoder from http://sp.parallels.com/download/plesk/billing/.
- Untar the fileset.
Use special parameters to preserve the file permissions set on the files/folders inside. It is important as the permissions are set properly on the
tmp"folder inside for it to be world readable and writable. The "
plesk-billing" folder will be created in your web-accessible folder.
# tar -xvzpfpleskbilling-fileset
- Copy your
config.phpfile back into place.
This is the only required file you must copy from your old fileset to the new one as it contains the necessary database connection information.
# cp plesk-billing.bak/lib-billing/include/config/config.php plesk-billing/lib-billing/include/config/config.php
- Upgrade Parallels Plesk Billing via Installation Wizard. You may access it directly (provided you're using SSL encryption) at the following URL:
Follow the instructions in the Installing Parallels Plesk Billing.
- When the upgrade wizard is complete, make sure to remove the
installdirectory before using the product by running the following command:
# rm -rf plesk-billing/admin/install
- Change Template (optional)
If you made any changes to the templates in Parallels Plesk Billing, now is the time to bring the changes over to the new fileset. Do not, under any circumstances, merely overwrite a particular template file or folder by copying it from the old fileset to the new fileset. You need to open your new files in a text-editor and merge your changes back in. Failure to transfer the templates properly will break your Parallels Plesk Billing if the template file being overwritten had been updated by our development team between the time your older version and the latest version were released.