Migration

[softdevsalon]

Hi, what to do when I decide to migrate the visiolist site? What do I need to do backup data and db. After that how or what to change in the file?

 

[Basti]

Old host
1) Backup all files
2) Backup database

On new host
1) Create a new database, upload your backup database
2) Upload your backed files
3) Update settings_sql.php with new database info

If your url has changed also
1) On new host update button_config.php and update urls to your new domain
2) Head to phpmyadmin, select your database and select the SQL tab. In there paste these queries to update your site urls, member banner urls etc
In each replace your old domain and new domain ( take note if old domain used www. and https or not )

UPDATE VL_settings SET list_url = REPLACE(list_url, 'http://old-domain.com', 'http://new-domain.com');
UPDATE VL_settings SET default_banner = REPLACE(default_banner, 'http://old-domain.com', 'http://new-domain.com');
UPDATE VL_sites SET banner_url = REPLACE(banner_url, 'http://old-domain.com', 'http://new-domain.com');
UPDATE VL_sites SET premium_banner_url = REPLACE(premium_banner_url, 'http://old-domain.com', 'http://new-domain.com');

And if your list is VisioList 1.6, these 2 additionally

UPDATE VL_sites SET mp4_url = REPLACE(mp4_url, 'http://old-domain.com', 'http://new-domain.com');
UPDATE VL_sites SET premium_mp4_url = REPLACE(premium_mp4_url, 'http://old-domain.com', 'http://new-domain.com');

​

 

[softdevsalon]

In each replace your old domain and new domain ( take note if old domain used www. and https or not )

Same domain name, but later on I will upgrade to https, do I need to run also the sql query? BTW im running visiolist as subdomain.

 

[Basti]

I would advise to run those query then also, yes. Because else you get warning like "site.com was loaded through a secure connection, but try loading a unsecure resource".

Maybe we can integrate those queries somehow into admin when someone switch from http to https and vise versa. But for now need to be done manually

 

[softdevsalon]

I would advise to run those query then also, yes. Because else you get warning like "site.com was loaded through a secure connection, but try loading a unsecure resource".

Maybe we can integrate those queries somehow into admin when someone switch from http to https and vise versa. But for now need to be done manually

What I did is that, I removed the subdomain and make it as subfolder so that I can apply https because my ssl cert is not wildcard. For now it runs on this format https://site.com/visiolistsite/. So I did a query on vl_settings to apply the url and put https.

 

[Basti]

Yep, good. Don't forget the other queries tho, else your banners wont be found