Join the community today
Register Now

Xenforo Xenforo 2.0.0 Beta 1 Released

Discussion in 'Forum software usage' started by eva2000, Sep 6, 2017.

Tags:
Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    Xenforo 2.0.0 Beta 1 has been released.
    upload_2017-9-6_11-48-24.png

    Xenforo 2.0.0 Beta 1 Install Guide on Centmin Mod LEMP Stack



    Only do test installs separate from live XF database/instance.

    Test XF 2.0.0 Beta 1 install on Centmin Mod 123.09beta01 and works fine. Used demo domain = newdomainx.com via local host file edit. With desired Xenforo 2 forum installed on web root of domain newdomainx.com. This is for HTTP (non-HTTPS based test setup). These are based on official Xenforo 2 Install docs at Getting started - XenForo 2.0 Documentation

    1. Create the Centmin Mod Nginx vhost as per official guide. I use nv command via SSH client type:
    Code (Text):
    nv -d newdomainx.com -s n -u YOURFTPUSERNAME
    

    • Nginx vhost conf path will be at /usr/local/nginx/conf/conf.d/newdomainx.com.conf
    • Vhost public web root will be at /home/nginx/domains/newdomainx.com/public
    • Vhost log directory will be at /home/nginx/domains/newdomainx.com/log
    Or if you have a working real domain/subdomain and DNS A record pointing to your Centmin Mod 123.09beta01 based server, you can use https://centminmod.com/acmetool addon to generate a Centmin Mod Nginx HTTP/2 based HTTPS vhost site and automatically obtain a free Letsencrypt SSL certificate using the guide outlined here Using Centmin Mod acmetool.sh addon for Nginx HTTP/2 based HTTPS with free Letsencrypt SSL certificates, the SSH commands would be after you follow the guide's instructions to enable addons/acmetool.sh addon.
    Code (Text):
    cd /usr/local/src/centminmod/addons
    ./acmetool.sh issue newdomainx.com lived
    

    That would generate Centmin Mod Nginx HTTP/2 based HTTPS vhost and site and obtain the free Letsencrypt SSL certificate and setup the domain to default to HTTPS and auto redirect HTTP to HTTPS for requests.

    Then the Nginx vhost path would change for the rest of below example from /usr/local/nginx/conf/conf.d/newdomainx.com.conf to /usr/local/nginx/conf/conf.d/newdomainx.com.ssl.conf
    • Nginx HTTP/2 HTTPS vhost conf path will be at /usr/local/nginx/conf/conf.d/newdomainx.com.ssl.conf
    • Vhost public web root will be at /home/nginx/domains/newdomainx.com/public
    • Vhost log directory will be at /home/nginx/domains/newdomainx.com/log
    2. Configure your Nginx vhost file with Nginx rules for Xenforo 2 use the official Centmin Mod Nginx vhost generator https://centminmod.com/vhost.php and enter the domain name = newdomainx.com and in vhost type select Xenforo and hit submit to generate the Nginx vhost for the domain. That generates a 123.08stable Nginx vhost format which is slightly different to 123.09beta01 Nginx vhost format. For 123.09beta01 Nginx vhost format, you can see example for newdomainx.com at xenforo 2 developer preview newdomainx.com example vhost. Note I commented out the include file for /usr/local/nginx/conf/autoprotect/newdomainx.com/autoprotect-newdomainx.com.conf.
    Code (Text):
    # comment out for https://community.centminmod.com/threads/autoprotect-sh-apache-htaccess-check-migration-to-nginx-deny-all.7308/
    # or setup .autoprotect-bypass files https://community.centminmod.com/posts/31027/ in /internal_data, /library and /src directories
    #include /usr/local/nginx/conf/autoprotect/newdomainx.com/autoprotect-newdomainx.com.conf;
    

    You may also want to add to Nginx vhost the following header to tell search engines not to index this test install
    Code (Text):
    add_header X-Robots-Tag "noindex, nofollow";
    

    I placed it after the 503include-main.conf commented out includes file
    Code (Text):
      # uncomment cloudflare.conf include if using cloudflare for
      # server and/or vhost site
      #include /usr/local/nginx/conf/cloudflare.conf;
      include /usr/local/nginx/conf/503include-main.conf;
      add_header X-Robots-Tag "noindex, nofollow";
    

    Test nginx vhost config and restart Nginx and PHP
    Code (Text):
    nginx -t
    nprestart
    


    3. Download Xenforo 2.0.0 Beta1 zip and rename to xenforo_2.0.0b1.zip and upload entire zip to new directory created at /home/nginx/domains/newdomainx.com/zips so /home/nginx/domains/newdomainx.com/zips/xenforo_2.0.0b1.zip

    Then to unzip file contents and give correct user/group permissions = nginx and copy the unziped upload/ directory files to newdomainx.com web root at /home/nginx/domains/newdomainx.com/public you do this via SSH client type:
    Code (Text):
    cd /home/nginx/domains/newdomainx.com/zips
    unzip xenforo_2.0.0b1.zip
    chown -R nginx:nginx upload
    cd upload
    \cp -Rpf * /home/nginx/domains/newdomainx.com/public
    


    4. Download xf2_config.sh generator script I wrote specifically for Centmin Mod LEMP installs and XF2 so that in future can automate the Xenforo 2 installs via SSH command line type the following. The script will ask for mysql database name, mysql username, mysql password and auto create them on the server and then generate the /home/nginx/domains/newdomainx.com/public/src/config.php config file and auto populate the settings in it.

    To download and setup /root/tools/xf2_config.sh type in SSH command
    Code (Text):
    mkdir -p /root/tools
    cd /root/tools
    rm -rf xf_config.sh
    wget https://gist.github.com/centminmod/89e8bc024b9eae8873092fd56b10088e/raw/xf2_config.sh
    chmod +x xf2_config.sh
    

    Now to generate the Xenforo 2 src/config.php file at /home/nginx/domains/newdomainx.com/public/src/config.php, you need to run xf2_config.sh and pass the desired path where config.php will reside = /home/nginx/domains/newdomainx.com/public/src.

    In SSH type:
    Code (Text):
    cd /root/tools
    ./xf2_config.sh /home/nginx/domains/newdomainx.com/public/src
    

    output from run
    Code (Text):
    ./xf2_config.sh /home/nginx/domains/newdomainx.com/public/src
    
    Enter desired MySQL database name: xd5
    Enter desired MySQL username: xu5
    Enter desired MySQL password: xp5
    
    GRANT USAGE ON *.* TO 'xu5'@'localhost' IDENTIFIED BY PASSWORD '*91DD20BB540FAAE3C54257D78203030A1BAC61F6'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `xd5`.* TO 'xu5'@'localhost'
    
    Grants for xu5@localhost
    GRANT USAGE ON *.* TO 'xu5'@'localhost' IDENTIFIED BY PASSWORD '*91DD20BB540FAAE3C54257D78203030A1BAC61F6'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `xd5`.* TO 'xu5'@'localhost'
    
    Setup /home/nginx/domains/newdomainx.com/public/src/config.php
    
    Created /home/nginx/domains/newdomainx.com/public/src/config.php
    

    Contents of auto generated Xenforo 2 src/config.php /home/nginx/domains/newdomainx.com/public/src/config.php
    Code (Text):
    cat /home/nginx/domains/newdomainx.com/public/src/config.php
    <?php
    
    $config['db']['host'] = 'localhost';
    $config['db']['port'] = '3306';
    $config['db']['username'] = 'xu5';
    $config['db']['password'] = 'xp5';
    $config['db']['dbname'] = 'xd5';
    $config['fullUnicode'] = 'true';
    


    5. Now to install Xenforo 2 via CLI command line, you run cmd.php from the Nginx vhost site's web root or where you placed the Xenforo 2 extracted zip files i.e. public web root = /home/nginx/domains/newdomainx.com/public
    Code (Text):
    cd /home/nginx/domains/newdomainx.com/public
    php cmd.php xf:install
    

    Then ensure proper file permissions
    Code (Text):
    chown -R nginx:nginx /home/nginx/domains/newdomainx.com/public
    

    example
    Code (Text):
    time php cmd.php xf:install
    All 3514 checked files are present and correct. :)
    Name of the administrator user (default: Admin): eva2000
    
    Password of the administrator user:
    
    Re-enter the administrator user password to confirm:
    
    Primary board email and email for administrator user (default: example@example.com): myemail@domain.com
    
    Board title (default: XenForo): Xenforo 2.0.0 Beta 1 on Centmin Mod LEMP Stack
    
    Board URL (default: http://localhost): http://newdomainx.com
    
    Creating tables...
     186/186 [============================] 100%
    Done.
    Creating default data...
     23/23 [============================] 100%
    Done. Importing data...
    
    Importing... Master data (Phrases)
    Importing... Master data (Phrases: 33.0%)
    Importing... Master data (Phrases: 57.5%)
    Importing... Master data (Phrases: 71.5%)
    Importing... Master data (Phrases: 82.8%)
    Importing... Master data (Templates)
    Importing... Master data (Templates: 50.3%)
    
    Master data rebuilt successfully. Time taken to import and rebuild: 59.20s
    Done. Apply installation configuration...
    
    All finished. Installation has been completed.
    
    Values set:
            * Username: eva2000
            * Email: myemail@domain.com
            * Password: **************** (Confirmed)
            * Title: Xenforo 2.0.0 Beta 1 on Centmin Mod LEMP Stack
            * URL: http://newdomainx.com
    
    Running clean up tasks...
    
    real    1m48.199s
    user    0m17.522s
    sys     0m2.131s
    


    6. Backup and ensure file permissions are set to nginx user/group - follow guide at https://community.centminmod.com/th...kup-restore-file-directory-permissions.10633/

    If you want to migrate to HTTPS based site, you can use Centmin Mod 123.09beta01's free Letsencrypt SSL certificate integration tools currently in beta testing. You can use the manual migration from HTTP to HTTPS guide at Migrating Existing Nginx Vhost From HTTP to HTTP/2 based HTTPS With Letsencrypt SSL Certificates to obtain free Letsencrypt SSL certificate and setup the Centmin Mod Nginx HTTPS vhost file.

    Xenforo 2.0.0 Beta 1 Reinstall Guide



    Xenforo 2.0.0 Beta 1 now allow you to upgrade in place instead of wiping preview instances to start again. So when a new release is made, you can do an in place upgrade.

    However, if you want to reinstall fresh, you can follow the above guide to install Xenforo 2.0.0 Beta 1 from scratch again via the below guide and SSH commands to reinstall the newer released Xenforo 2.0.0 Betas :)

    1. Upload new Xenforo 2.0.0 Beta release zip to /home/nginx/domains/newdomainx.com/zips renamed as xenforo_2.0.0b1.zip or as you desire

    2. If you defined your MySQL database name as above as xd5, then assign it to the dbname variable below and assign to domain variable your domain name i.e. above example used newdomainx.com.
    Code (Text):
    dbname=xd5
    domain='newdomainx.com'
    

    Then run these below commands
    Code (Text):
    dbname=xd5
    domain='newdomainx.com'
    if [ ! "$(grep -w "$dbname" /home/nginx/domains/${domain}/public/src/config.php)" ]; then   echo "$dbname not listed in /home/nginx/domains/${domain}/public/src/config.php"; fi
    echo 'y' | mysqladmin drop $dbname
    mysqladmin create $dbname
    rm -rf /home/nginx/domains/${domain}/zips/XF2-INSTALL.txt
    rm -rf /home/nginx/domains/${domain}/zips/xenforo_2.0.0
    rm -rf /home/nginx/domains/${domain}/zips/upload
    rm -rf /home/nginx/domains/${domain}/public/data/*
    rm -rf /home/nginx/domains/${domain}/public/internal_data/*
    cd /home/nginx/domains/${domain}/zips
    unzip xenforo_2.0.0b1.zip
    chown -R nginx:nginx upload
    cd upload
    \cp -Rpf * /home/nginx/domains/${domain}/public
    cd /home/nginx/domains/${domain}/public
    php cmd.php xf:install
    chown -R nginx:nginx /home/nginx/domains/${domain}/public
    

    That's it new Xenforo 2.0.0 Beta release installed :)

    Xenforo 2.0.0 Beta 1 Admin

    upload_2017-9-6_11-51-10.png

    Server Setup
    • CentOS 7.3 64bit
    • Nginx 1.13.5
    • PHP 7.1.19 + Zend Opcache
    • MariaDB 10.1.26 MySQL
    • Centmin Mod 123.09beta01 LEMP stack
    • 2 CPU Intel Xeon E5-1650v2 OpenVZ VPS
    • 2GB RAM
    • 50GB DISK
    • Dallas, TX
    • US$25/yr OpenVZ VPS
     
    Last edited: Sep 6, 2017
    • Like Like x 1
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    XF 2 Beta 1 Addons



    upload_2017-9-6_12-3-13.png

    upload_2017-9-6_12-3-48.png

    upload_2017-9-6_12-4-48.png

    Installed

    upload_2017-9-6_12-23-50.png

    With Media Gallery, Resource Manage and Enhanced Search addons installed

    upload_2017-9-6_12-28-30.png
     
    Last edited: Sep 6, 2017
    • Informative Informative x 1
  3. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Enhanced Search Beta 1 Options



    upload_2017-9-6_12-25-47.png
    upload_2017-9-6_12-26-20.png
     
    • Informative Informative x 1
  4. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 Media Gallery



    Seems a few bugs on image upload

    Code (Text):
    ErrorException: array_keys() expects parameter 1 to be array, null given in src/addons/XFMG/Notifier/Media/CategoryWatch.php at line 70
    [LIST=1]
    [*]XF::handlePhpError()
    [*]array_keys() in src/addons/XFMG/Notifier/Media/CategoryWatch.php at line 70
    [*]XFMG\Notifier\Media\CategoryWatch->getDefaultNotifyData() in src/XF/Service/AbstractNotifier.phpat line 258
    [*]XF\Service\AbstractNotifier->ensureDataLoaded() in src/XF/Service/AbstractNotifier.php at line 31
    [*]XF\Service\AbstractNotifier->notify() in src/XF/Service/AbstractNotifier.php at line 56
    [*]XF\Service\AbstractNotifier->notifyAndEnqueue() in src/addons/XFMG/Service/Media/Creator.php at line 282
    [*]XFMG\Service\Media\Creator->sendNotifications() in src/addons/XFMG/Pub/Controller/Media.php at line 664
    [*]XFMG\Pub\Controller\Media->finalizeMediaItemCreate() insrc/addons/XFMG/Pub/Controller/Media.php at line 741
    [*]XFMG\Pub\Controller\Media->actionSaveMedia() in src/XF/Mvc/Dispatcher.php at line 232
    [*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
    [*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    [*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
    [*]XF\App->run() in src/XF.php at line 319
    [*]XF::runApp() in index.php at line 13
    [/LIST]
    


    upload_2017-9-6_12-31-46.png

    But images do upload

    upload_2017-9-6_12-33-10.png upload_2017-9-6_12-33-49.png
     
    • Informative Informative x 1
  5. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 Resource Manager



    Seems Resource Manager is buggy too right now, adding a new resource to example category gives
    Code (Text):
    ErrorException: A non-numeric value encountered in src/XF/Mvc/Entity/Entity.php at line 748
    XF::handlePhpError() in src/XF/Mvc/Entity/Entity.php at line 748
    XF\Mvc\Entity\Entity->_castValueToType() in src/XF/Mvc/Entity/Entity.php at line 614
    XF\Mvc\Entity\Entity->set() in src/XF/Mvc/Entity/Entity.php at line 554
    XF\Mvc\Entity\Entity->__set() in src/addons/XFRM/Pub/Controller/Category.php at line 296
    XFRM\Pub\Controller\Category->actionAdd() in src/XF/Mvc/Dispatcher.php at line 232
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
    XF\App->run() in src/XF.php at line 319
    XF::runApp() in index.php at line 13


    upload_2017-9-6_12-35-36.png
     
    • Informative Informative x 1
  6. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 Enhanced Search



    Test post & search

    upload_2017-9-6_13-34-44.png

    search for nginx

    upload_2017-9-6_13-35-52.png

    Enhanced Search stats

    upload_2017-9-6_13-36-35.png
     
    • Informative Informative x 1
  7. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 MySQL Info



    Breakdown of MySQL Engines used for Xenforo 2.0.0 Beta 1 tables
    Code (Text):
    +--------+--------+-------+---------+--------+------------+---------+
    | engine | tables | rows  | data    | idx    | total_size | idxfrac |
    +--------+--------+-------+---------+--------+------------+---------+
    | InnoDB |    214 | 44106 | 34.39MB | 8.80MB | 43.19MB    |    0.26 |
    | MEMORY |      5 | 2     | 0.06MB  | 0.06MB | 0.12MB     |    1.00 |
    | MyISAM |      4 | 6     | 0.00MB  | 0.01MB | 0.01MB     |    8.26 |
    +--------+--------+-------+---------+--------+------------+---------+
    


    Xenforo 2.0.0 Beta 1 tables
    Code (Text):
    +--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
    | Table Name                                 | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION    |
    +--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
    | xd5.xf_addon                             | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_admin                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_admin_log                         | 66 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_admin_navigation                  | 136 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_admin_permission                  | 29 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_admin_permission_entry            | 28 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_advertising                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_advertising_position              | 23 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_approval_queue                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_attachment                        | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_attachment_data                   | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_attachment_view                   | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | xd5.xf_ban_email                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_bb_code                           | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_bb_code_media_site                | 18 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_captcha_log                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_captcha_question                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_category                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_change_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_class_extension                   | 9 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_code_event                        | 61 Rows        | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_code_event_listener               | 18 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_connected_account_provider        | 7 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_content_spam_cache                | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_content_type_field                | 183 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_conversation_master               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_conversation_message              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_conversation_recipient            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_conversation_user                 | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_cron_entry                        | 22 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_css_cache                         | 24 Rows        | InnoDB         | 1.52MB    | 0.02MB     | 1.53MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_data_registry                     | 39 Rows        | InnoDB         | 0.25MB    | 0.00MB     | 0.25MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_deletion_log                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_draft                             | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_edit_history                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_email_bounce_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_email_bounce_soft                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_error_log                         | 5 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_es_index_failed                   | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_feed                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_feed_log                          | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_file_check                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_find_new                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_find_new_default                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_flood_check                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum_field                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum_prefix                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum_prompt                      | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum_read                        | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_forum_watch                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_help_page                         | 5 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_image_proxy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_image_proxy_referrer              | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_import_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_ip                                | 6 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_ip_match                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_job                               | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_language                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_liked_content                     | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_link_forum                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_link_proxy                        | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_link_proxy_referrer               | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_login_attempt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mail_queue                        | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_member_stat                       | 8 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_album                          | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_album_comment_read             | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_album_view                     | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | xd5.xf_mg_album_watch                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_category                       | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_category_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_category_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_comment                        | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_comment_read             | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_field                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_field_value              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_item                     | 2 Rows         | InnoDB         | 0.02MB    | 0.09MB     | 0.11MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_note                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_temp                     | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_user_view                | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_media_view                     | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | xd5.xf_mg_media_watch                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_rating                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_shared_map_add                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_shared_map_view                | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_mg_transcode_queue                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_moderator                         | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_moderator_content                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_moderator_log                     | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_navigation                        | 52 Rows        | InnoDB         | 0.06MB    | 0.02MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_navigation_type                   | 3 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_news_feed                         | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_node                              | 2 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_node_type                         | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_notice                            | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_notice_dismissed                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_oembed                            | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_oembed_referrer                   | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_option                            | 204 Rows       | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_option_group                      | 30 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_option_group_relation             | 240 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_page                              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_payment_profile                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_payment_provider                  | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_payment_provider_log              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission                        | 197 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_cache_content          | 8 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_combination            | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_combination_user_group | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_entry                  | 212 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_entry_content          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_permission_interface_group        | 19 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_phrase                            | 6317 Rows      | InnoDB         | 1.52MB    | 0.58MB     | 2.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_phrase_compiled                   | 13647 Rows     | InnoDB         | 2.52MB    | 0.00MB     | 2.52MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_phrase_map                        | 12374 Rows     | InnoDB         | 1.02MB    | 2.69MB     | 3.70MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_poll                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_poll_response                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_poll_vote                         | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_post                              | 1 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_profile_post                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_profile_post_comment              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_purchasable                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_purchase_request                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_registration_spam_cache           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_report                            | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_report_comment                    | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_category                       | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_category_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_category_prefix                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_category_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource                       | 0 Rows         | InnoDB         | 0.02MB    | 0.11MB     | 0.13MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_download              | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_feature               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_field_value           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_prefix                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_prefix_group          | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_rating                | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_update                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_version               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_rm_resource_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_route                             | 178 Rows       | InnoDB         | 0.05MB    | 0.02MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_route_filter                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_search                            | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_search_index                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | xd5.xf_session                           | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | xd5.xf_session_activity                  | 2 Rows         | MEMORY         | 0.06MB    | 0.06MB     | 0.12MB  | Fixed      | utf8mb4_general_ci |
    | xd5.xf_session_admin                     | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | xd5.xf_session_install                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | xd5.xf_sitemap                           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_smilie                            | 31 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_smilie_category                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_spam_cleaner_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_spam_trigger_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_stats_daily                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_style                             | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_style_property                    | 208 Rows       | InnoDB         | 0.08MB    | 0.02MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_style_property_group              | 28 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_style_property_map                | 416 Rows       | InnoDB         | 0.06MB    | 0.03MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_tag                               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_tag_content                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_tag_result_cache                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_template                          | 830 Rows       | InnoDB         | 23.52MB   | 0.13MB     | 23.64MB | Compact    | utf8mb4_general_ci |
    | xd5.xf_template_history                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_template_map                      | 2382 Rows      | InnoDB         | 0.17MB    | 0.23MB     | 0.41MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_template_modification             | 14 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_template_modification_log         | 14 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_template_phrase                   | 5868 Rows      | InnoDB         | 0.39MB    | 0.28MB     | 0.67MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_tfa_attempt                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_tfa_provider                      | 3 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread                            | 1 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_field                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_field_value                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_prefix                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_prefix_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_prompt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_prompt_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_read                       | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_redirect                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_reply_ban                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_user_post                  | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_thread_view                       | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | xd5.xf_thread_watch                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_trophy                            | 9 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_upgrade_job                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_upgrade_log                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user                              | 1 Rows         | InnoDB         | 0.02MB    | 0.19MB     | 0.20MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_alert                        | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_alert_optout                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_authenticate                 | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_ban                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_change_temp                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_confirmation                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_connected_account            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_field                        | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_field_value                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_follow                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_group                        | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_group_change                 | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_group_promotion              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_group_promotion_log          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_group_relation               | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_ignored                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_option                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_privacy                      | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_profile                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_reject                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_remember                     | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_tfa                          | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_tfa_trusted                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_title_ladder                 | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_trophy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_upgrade                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_upgrade_active               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_user_upgrade_expired              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_warning                           | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_warning_action                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_warning_action_trigger            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_warning_definition                | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_widget                            | 15 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_widget_definition                 | 22 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
    | xd5.xf_widget_position                   | 23 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
    +--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
    
     
    • Informative Informative x 1
  8. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 Debug Mode



    Some styling bugs it seems

    upload_2017-9-6_13-47-3.png

    Code (Text):
    Page Time: 0.0233s
    Memory: 2.4638 MB (Peak: 2.5486 MB)
    Queries (15, time: 0.0040s, 17.1%)
     
    • Informative Informative x 1
  9. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Informative Informative x 1
  10. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 1 Native Redis Server Support



    Update, Xenforo 2.0.0 Beta 1 has a few bugs for Redis support which would be resolved in 2.0.0 Beta 2.

    Xenforo 2.0 supports Redis server caching natively out of the box it seems.
    Need to make sure PHP has Redis PHP extension installed. Centmin Mod 123.09beta01 by default installs Redis PHP extension
    Code (Text):
    php --ri redis
    
    redis
    
    Redis Support => enabled
    Redis Version => 3.1.3
    Available serializers => php, igbinary
    


    You'd need to install Redis server via Remi YUM repo yourself if you haven't already as outlined at https://community.centminmod.com/threads/how-to-install-redis-server-on-centmin-mod-lemp-stack.4546/. Or use redis-install.sh script I wrote for redis-generator.sh project. Using these SSH commands on your Centmin Mod 123.09beta01 based LEMP stack server.
    Code (Text):
    cd /root/tools/
    git clone https://github.com/centminmod/centminmod-redis
    cd centminmod-redis
    ./redis-install.sh install
    

    Edit /etc/redis.conf and remove the requiredpass line if it exists
    Code (Text):
    requirepass xfxxxxxx
    

    restart Redis server
    Code (Text):
    service redis restart
    

    check redis info via redis-cli info command
    Code (Text):
    redis-cli info  
    # Server
    redis_version:4.0.1
    redis_git_sha1:00000000
    redis_git_dirty:0
    redis_build_id:b9e3021da3c16feb
    redis_mode:standalone
    os:Linux 2.6.32-042stab116.1 x86_64
    arch_bits:64
    multiplexing_api:epoll
    atomicvar_api:atomic-builtin
    gcc_version:4.8.5
    process_id:2721
    run_id:31560ad218d5daf8c4be9972fa5f236cf97e4f46
    tcp_port:6379
    uptime_in_seconds:3
    uptime_in_days:0
    hz:10
    lru_clock:11499476
    executable:/usr/bin/redis-server
    config_file:/etc/redis.conf
    
    # Clients
    connected_clients:1
    client_longest_output_list:0
    client_biggest_input_buf:0
    blocked_clients:0
    
    # Memory
    used_memory:513136
    used_memory_human:501.11K
    used_memory_rss:2437120
    used_memory_rss_human:2.32M
    used_memory_peak:513136
    used_memory_peak_human:501.11K
    used_memory_peak_perc:112.94%
    used_memory_overhead:503982
    used_memory_startup:454352
    used_memory_dataset:9154
    used_memory_dataset_perc:15.57%
    total_system_memory:2147483648
    total_system_memory_human:2.00G
    used_memory_lua:37888
    used_memory_lua_human:37.00K
    maxmemory:0
    maxmemory_human:0B
    maxmemory_policy:noeviction
    mem_fragmentation_ratio:4.75
    mem_allocator:jemalloc-3.6.0
    active_defrag_running:0
    lazyfree_pending_objects:0
    
    # Persistence
    loading:0
    rdb_changes_since_last_save:0
    rdb_bgsave_in_progress:0
    rdb_last_save_time:1504671697
    rdb_last_bgsave_status:ok
    rdb_last_bgsave_time_sec:-1
    rdb_current_bgsave_time_sec:-1
    rdb_last_cow_size:0
    aof_enabled:0
    aof_rewrite_in_progress:0
    aof_rewrite_scheduled:0
    aof_last_rewrite_time_sec:-1
    aof_current_rewrite_time_sec:-1
    aof_last_bgrewrite_status:ok
    aof_last_write_status:ok
    aof_last_cow_size:0
    
    # Stats
    total_connections_received:3
    total_commands_processed:4
    instantaneous_ops_per_sec:1
    total_net_input_bytes:56
    total_net_output_bytes:108
    instantaneous_input_kbps:0.01
    instantaneous_output_kbps:0.03
    rejected_connections:0
    sync_full:0
    sync_partial_ok:0
    sync_partial_err:0
    expired_keys:0
    evicted_keys:0
    keyspace_hits:0
    keyspace_misses:0
    pubsub_channels:0
    pubsub_patterns:0
    latest_fork_usec:0
    migrate_cached_sockets:0
    slave_expires_tracked_keys:0
    active_defrag_hits:0
    active_defrag_misses:0
    active_defrag_key_hits:0
    active_defrag_key_misses:0
    
    # Replication
    role:master
    connected_slaves:0
    master_replid:d3038a0ae2a0573ae05fa86b05c31ef3d46c42b6
    master_replid2:0000000000000000000000000000000000000000
    master_repl_offset:403074
    second_repl_offset:-1
    repl_backlog_active:0
    repl_backlog_size:1048576
    repl_backlog_first_byte_offset:0
    repl_backlog_histlen:0
    
    # CPU
    used_cpu_sys:0.00
    used_cpu_user:0.00
    used_cpu_sys_children:0.00
    used_cpu_user_children:0.00
    
    # Cluster
    cluster_enabled:0
    
    # Keyspace
    


    add to src/config.php - TBA need confirmation from XF folks of correct syntax
     
    Last edited: Sep 6, 2017
    • Informative Informative x 1
  11. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta1 + ngx_pagespeed + Brotli



    Testing Centmin Mod 123.09beta01's Nginx HTTP/2 HTTPS + Google ngx_pagespeed nginx module + Google Brotli compression replacing gzip/deflate HTTP compression :)

    xf2-200beta1-ngx-pagespeed-brotli-01.png

    GTMetrix, Webpagetest and Google Insight numbers

    xf2-200beta1-ngx-pagespeed-brotli-gtmetrix-dallas-02.png

    xf2-200beta1-ngx-pagespeed-brotli-insights-dallas-01.png

    xf2-200beta1-ngx-pagespeed-brotli-insights-dallas-02.png
    xf2-200beta1-ngx-pagespeed-brotli-wpt-dallas-02.png
    xf2-200beta1-ngx-pagespeed-brotli-wpt-dallas-03.png
     
    Last edited: Sep 12, 2017
    • Winner Winner x 1
  12. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0 Replication Master/Slave Adapter



    Good news XF 2 will support splitting MySQL reads and writes via MySQL replication master/slave configurations Implemented - [SUGGESTION] MySQL Read-Slave, Write-Master

     
    • Informative Informative x 1
  13. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 2 Release Upgrade



    Xenforo 2.0.0 Beta 2 has been released along with official XF addons for Enhanced Search, Resource Manager and Media Gallery. You can upgrade the old XF 1.x method - upload files and run upgrade within admin area. Or use the new PHP CLI command line method via SSH from within the Xenforo 2 install directory.

    For me using the above CLI install method, the upgrade would simply be the following SSH commands after you have uploaded the updated versions and a nginx + php-fpm restart via (nprestart) to clear Zend Opcache caching.

    Code (Text):
    domain='newdomainx.com'
    cd /home/nginx/domains/${domain}/public
    nprestart
    time php cmd.php xf:upgrade
    time php cmd.php xf:addon-upgrade XFES
    time php cmd.php xf:addon-upgrade XFMG
    time php cmd.php xf:addon-upgrade XFRM
    nprestart
    

    Example Xenforo 2.0.0 Beta 2 upgrade output where total combined time for upgrade was 75 seconds on 2 cpu core, 2GB memory OpenVZ server running Intel Xeon E5-1650v3 @3.5Ghz cpu.
    Code (Text):
    time php cmd.php xf:upgrade
    Current version: 2000031
    Upgrade target: 2000032 (2.0.0 Beta 2)
    Are you sure you want to continue with the upgrade? [y/n] y
    
    Running upgrade to 2.0.0 Beta 2, step 1... done.
    Running upgrade to 2.0.0 Beta 2, step 2... done.
    Importing... Master data (Templates)
    Importing... Master data (Templates: 25.6%)
    Importing... Master data (Templates: 56.5%)
    Rebuilding... Phrases .
    
    Upgrade completed successfully.
    
    real    0m47.439s
    user    0m18.573s
    sys     0m1.570s
    

    Code (Text):
    time php cmd.php xf:addon-upgrade XFES
    Please confirm that you want to upgrade the following add-on: (XenForo Enhanced Search 2.0.0 Beta 1) (y/n)y
    Upgrading
    Complete.
    
    Importing add-on data
    Importing... Add-on data (Admin navigation)
    Importing... Add-on data (Code event listeners)
    Importing... Add-on data (Cron)
    Importing... Add-on data (Options)
    Importing... Add-on data (Phrases)
    Importing... Add-on data (Routes)
    Importing... Add-on data (Templates)
    
    
    real    0m14.042s
    user    0m0.500s
    sys     0m0.100s
    

    Code (Text):
    time php cmd.php xf:addon-upgrade XFMG
    Please confirm that you want to upgrade the following add-on: (XenForo Media Gallery 2.0.0 Beta 1) (y/n)y
    Upgrading .
    Complete.
    
    Importing add-on data
    Importing... Add-on data (Admin navigation)
    Importing... Add-on data (Admin permission)
    Importing... Add-on data (Bb codes)
    Importing... Add-on data (Class extensions)
    Importing... Add-on data (Code events)
    Importing... Add-on data (Code event listeners)
    Importing... Add-on data (Content type fields)
    Importing... Add-on data (Cron)
    Importing... Add-on data (Member stats)
    Importing... Add-on data (Navigation)
    Importing... Add-on data (Options)
    Importing... Add-on data (Option groups)
    Importing... Add-on data (Permissions)
    Importing... Add-on data (Permission interface groups)
    Importing... Add-on data (Phrases)
    Importing... Add-on data (Routes)
    Importing... Add-on data (Style properties)
    Importing... Add-on data (Style property groups)
    Importing... Add-on data (Templates)
    Importing... Add-on data (Template modifications)
    Importing... Add-on data (Widget definitions)
    Importing... Add-on data (Widget positions)
    
    
    real    0m7.713s
    user    0m2.655s
    sys     0m0.197s
    

    Code (Text):
    time php cmd.php xf:addon-upgrade XFRM
    Please confirm that you want to upgrade the following add-on: (XenForo Resource Manager 2.0.0 Beta 1) (y/n)y
    Upgrading
    Complete.
    
    Importing add-on data
    Importing... Add-on data (Admin navigation)
    Importing... Add-on data (Admin permission)
    Importing... Add-on data (Class extensions)
    Importing... Add-on data (Code event listeners)
    Importing... Add-on data (Content type fields)
    Importing... Add-on data (Member stats)
    Importing... Add-on data (Navigation)
    Importing... Add-on data (Options)
    Importing... Add-on data (Option groups)
    Importing... Add-on data (Permissions)
    Importing... Add-on data (Permission interface groups)
    Importing... Add-on data (Phrases)
    Importing... Add-on data (Routes)
    Importing... Add-on data (Templates)
    Importing... Add-on data (Template modifications)
    Importing... Add-on data (Widget definitions)
    Importing... Add-on data (Widget positions)
    
    
    real    0m6.007s
    user    0m2.478s
    sys     0m0.170s
    

    Thanks @Chris D for heads up on CLI upgrade instructions :D
     
    • Like Like x 2
  14. eva2000

    eva2000 Administrator Staff Member

    29,732
    6,713
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,023
    Local Time:
    2:01 PM
    Nginx 1.13.x
    MariaDB 5.5

    Xenforo 2.0.0 Beta 2 MySQL Table Structures



    If you're testing upgrades from an existing Xenforo 1.5.x install with 3rd party addons, then some of the standard Xenforo database tables may have additional fields, indexes or columns added which Xenforo 2.x upgrade installer might not expect. So you need to visually be able to compare the two if you run into upgrade issues.

    You can use my mysqlmymonlite.sh script to do just that as outlined here. The mysqlmymonlite.sh has a showcreate option which can output a MySQL database's table structures either to SSH stdout screen which you copy and paste into a file or output to individual database table named text files (which is harder to do visual compare with). Example outlined here of showcreate option.

    Install mysqlmymonlite.sh on Centmin Mod servers - this is one whole line command
    Code (Text):
    mkdir -p /root/tools; cd /root/tools; rm -rf /root/mysqltuner.pl; rm -rf mysqlmymonlite.sh; wget http://mysqlmymon.com/download/mysqlmymonlite.zip; unzip -o mysqlmymonlite.zip; mv centos/mysqlmymonlite.sh .; rm -rf mysqlmymonlite.zip centos centos_whm debian changelog*; chmod +x mysqlmymonlite.sh
    


    run mysqlmymonlite.sh showcreate and output database tables for database named = DBNAME. The output is to screen so you need for your SSH client's scrollback buffer to be larger i.e. 256000 rows. Just highlight and copy and paste output to a text file. Do the same for both Xenforo 1.5.x and 2.x database names. So you end up with 2 text files and just use a file comparison tool to compare table structures. If you install a fresh test Xenforo 1.5.x instance, you can have a 3rd database showcreate text file for default XF 1.5 database table structure so you can do file compare between XF 1.5 default vs XF 1.5 your custom install vs XF 2.x.
    Code (Text):
    ./mysqlmymonlite.sh showcreate
    

    Code (Text):
    ./mysqlmymonlite.sh showcreate
    
    What is your mysql database name ? DBNAME
    
    Do you want to display all DBNAME tables' schema (how table was created) ? [y/n] y
    
    Do you want save output to text file ? Answering no will output only to screen. [y/n] n
    

    sample output would be
    Code (Text):
    *************************** 1. row ***************************
           Table: xf_addon
    Create Table: CREATE TABLE `xf_addon` (
      `addon_id` varbinary(50) NOT NULL,
      `title` varchar(75) NOT NULL,
      `version_string` varchar(30) NOT NULL DEFAULT '',
      `version_id` int(10) unsigned NOT NULL DEFAULT '0',
      `json_hash` varbinary(64) NOT NULL DEFAULT '',
      `active` tinyint(3) unsigned NOT NULL,
      `is_legacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `is_processing` tinyint(3) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`addon_id`),
      KEY `title` (`title`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
    *************************** 1. row ***************************
           Table: xf_admin
    Create Table: CREATE TABLE `xf_admin` (
      `user_id` int(10) unsigned NOT NULL,
      `extra_user_group_ids` varbinary(255) NOT NULL,
      `last_login` int(10) unsigned NOT NULL DEFAULT '0',
      `permission_cache` mediumblob,
      `admin_language_id` int(10) unsigned NOT NULL DEFAULT '0',
      `is_super_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`user_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
    *************************** 1. row ***************************
    


    Example using file compare tool Beyondcompare for my XF 1.5 install database structure (left) and XF 2.0.0 beta2 (right)

    xf15-vs-xf200b2-showcreate-01.png
    xf15-vs-xf200b2-showcreate-02.png
     
    • Winner Winner x 2
Thread Status:
Not open for further replies.