FunnelFlux - 1.6x Upgrade Instructions

1) To do a backup you need to obtain the database name for your FunnelFlux installation. You need to check ../includes/appConfig.php file under your installation directory to get your database name.

You need 50% disk space free after you perform the backup. You can first decide if you have enough disk space by checking your FunnelFlux database size (run in SSH prompt):

du -h /var/lib/mysql/DB_NAME

# where DB_NAME is the name of your FunnelFlux database. You can obtain your DB_NAME from "../includes/appConfig.php"

Another method is to run the following query on your FunnelFlux database and compute the size yourself:

SELECT
table_schema as `Database`,
sum( round(((data_length + index_length) / 1024 / 1024 / 1024), 2) ) `Size in GB`
FROM information_schema.TABLES
GROUP BY `Database`
ORDER BY `Size in GB`  DESC;

2) In the SSH terminal perform the following for the database backup (where DB_NAME is the name of the database from appConfig.php from previous step) , then archiving and deleting the dump file (you can use other directory than /root).

cd /root
mysqldump --routines DB_NAME > funnelflux_database_backup.sql
tar cvzf funnelflux_database_backup.tgz funnelflux_database_backup.sql
rm -rf funnelflux_database_backup.sql

3) In the FunnelFlux installation directory (under your web server directory) you need to backup your installation files also. You can use a directory of your preference to move the backup archive. It's moved in /root in this directive (begin in the SSH prompt below):

tar cvzf funnelflux_installation_files_backup.tgz *
mv funnelflux_installation_files_backup.tgz /root

4) Done with the backup. Both backup archives reside in /root directory but you can modify this per your preference.

5) Proceed with the upgrade below:

6) Make sure you are running FunnelFlux version 1.5193 (you can check in the footer of your Admin dashboard) and the server has at least 50% disk space available after you performed full backups on database and installation files.

To check disk space you can run (in the SSH prompt):

df -h

7) Check the IonCube to be at least 6.0.9 and perform an upgrade (run in SSH prompt):

php -v

example guide: https://www.rosehosting.com/blog/install-ioncube-loader-on-centos-7/

8) You need to check that there's no reset / cost update / conversion update background job not completed yet before replacing the files! Check under FunnelFlux admin dashboard to make sure all background jobs completed!

9) Download the latest version.Go to your FunnelFlux original installation directory (under your web server directory):

wget http://www.funnelflux.com/1.6.zip

10) Make a note of what are the original file/folder ownership under your FunnelFlux installation directory (will be used below for ORIGINAL_USER:ORIGINAL_GROUP to be restored):

ls -la

11) Unzip and overwrite the original FunnelFlux files with the new archive:

unzip 1.6.zip

12) Make sure file permissions/ownership are restored for the whole new overwritten files (under your FunnelFlux installation directory):

chown ORIGINAL_USER:ORIGINAL_GROUP * -R

13) Under your FunnelFlux installation directory , go to "admin/tools/" folder and run:

php upgrade1600.php

14) Run file folder permission fix again after the installation (step 12)

15) After the upgrade is successfull, run query on your FunnelFlux database(in the SSH prompt):

mysql YOUR_DB_NAME
==>  delete from meta where meta_key = 'latest-maxmindisp-download';

16) Check your new upgraded Admin dashboard to see if your installation went successful. Please allow sufficient time for the background jobs to complete re-caching for stats to start to appear.

17) If you need to restore the files from the backups you need to replace-overwrite the files in your FunnelFlux installation folder (with the backup archive made from first steps) and then import the decompressed database dump into a new database (or you can reuse your existing database by first clearing it).

If you are using a new database for the restore - you need to update "../includes/appConfig.php" file with the new database access credentials.

That's it!

If you have any questions please reach out to our support@funnelflux.com who can assist with any upgrade and checking your server requirements.

Our tech support are more than willing to help other tech admins with the upgrade process and with any relevant questions.