[freeside-users] import 3.6git database into 4.1 ?

[Erreu Gedmon]

I haven't tested it, but you could try something like this:

su -l freeside -c '/usr/bin/freeside-backup fs_daily' # create a backup, copy it to the 4.1 system

/etc/init.d/freeside stop ; pkill -f freeside ; systemctl stop apache2 ; systemsctl restart postgres # stop the 4.1 system
createdb -E UTF8 freeside' # create the database if it doesn't exist (I can't recall if this step is necessary)
su -l freeside -c 'pg_restore --dbname freeside -Fc freeside_backup.Pg' # restore the database
su -l freeside -c "freeside-upgrade fs_daily" # upgrade the 3.6 data to 4.1
/etc/init.d/freeside restart

Erreu Gedmon

--
"You see persons and things not as they are but as you are."
        -- Anthony De Mello

On 12/05/2016 03:22 PM, Ian Fraser wrote:
>
> I have a production 3.6git  instance of Freeside.  'Upgrading' a mirrored development copy has not gone well.
>
>
> Is it possible to import a 3.6 db into a clean 4.1 install or a 4.1 VMWare image ?
>
>
> Thanks,
> Ian
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users