===============================================================================================================================================
New Vconsult Setup:
Step 1: Login Webmin Dashboard.
Step 2: Under Tools ->File Manager->etc->apache2->site_avaiable->create 2 new files->mcode.thevconsult.net.conf and mcode.thevconsult.net-le-ssl.conf
Step 3: Open mcode.thevconsult.net.conf(etc/apache2/site_avaiable) prompt -- Copy data from old config file and paste in new config file, edit the ods code within the file
Step 4: usr/local/share/ca-certificates[Open Vconsult Pem File] [Prompt] : Run sudo a2ensite mcode.thevconsult.net.conf
Step 5: Enable Site(To Restart Apache) : systemctl reload apache2
Step 6:To Install SSL : sudo certbot --apache
Step 7:Add mcode in vconsult_configuration.php
Step 8:Move vconsult_configuration.php file on test server / master server
Step 9:Set Password [var/www/The v-Consult]prompt : mysql -u root -p
Step 10:[var/www/The v-Consult]prompt :Enter Password:ss#$2432
Step 11:[var/www/The v-Consult]prompt :CREATE USER 'thevconsult_c12345'@'localhost' identified with mysql_native_password by 'gCTedsCeccc12345';
GRANT ALL PRIVILEGES ON thevconsult_c12345.* TO 'thevconsult_c12345'@'localhost' WITH GRANT OPTION;
Step 12: Create Database
Step 13: Copy Existing database To New database
Step 14: Truncate table except two-three table in new database
FLUSH PRIVILEGES;
Step 15:[var/www/The v-Consult]prompt : exit
Step 16:check log :mcode.thevconsult.net/log-viewer
=====================================================================================================================================================
============================================================================================================================================================
Install SSL Certificate:
Step 1: Login IONOS
URL:login.ionos.co.uk/password#
Username:177830797
Password:M0NIbl*ajeb?A0U1Ah9$
Step 2: Click Domain & SSL
Step 3: Search Input Field :thevconsult
Step 4:Click Domain thevconsult.net
Step 5:Go To Subdomain Tab
Step 6:Create Subdomain
Step 7:Write Subdomain name: mcode
Step 8:Check Point IPv4:35.178.229.221 [Optional]
================================================================================================================================================================
======================================================================================================================================================
Create New Database On Workbench:
Step 1: Click File.
Step 2: Under File Tab Click New Query Tab.
Step 3:CREATE DATABASE database_name;
Step 4:Press Ctrl+Enter;
Step 5:Under Schema Panel Click Right Click and Select Refresh All.
Step 6: Search New Database
Step 7:Go to Server > Data Export.
Step 8: Select old prefer database.
Step 9:Select Dump Structure and Data And Export to Self-Contained File.
Step 10:Click Start Export.
Step 11:Go to Server > Data Import.
Step 12:Select Import from Self-Contained File, then browse to your .sql file.
Step 13:Under Default Schema to be Imported To, select your new database (create it beforehand if needed).
Step 14:Click Start Import.
Step 15:Delete old data
=============================================================================================================================================================