Migration

Discussion in 'General Help' started by softdevsalon, Mar 1, 2019.

  1. softdevsalon
    • Licensed

    softdevsalon Member

    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?
  2. Basti
    • Staff

    Basti Administrator Staff Member

    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 )
    Code:
    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
    Code:
    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 likes this.
  3. softdevsalon
    • Licensed

    softdevsalon Member

    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.
  4. Basti
    • Staff

    Basti Administrator Staff Member

    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
  5. softdevsalon
    • Licensed

    softdevsalon Member

    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.
  6. Basti
    • Staff

    Basti Administrator Staff Member

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

Share This Page