Create a “localhost/cgpgoldo” test website 

This is a “from scratch” build of the website:

    • If “xampp” is installed, uninstall it.  
        - Install “xampp-windows-x64-7.3.11-0-VC15-installer.exe” version of “xampp” in “C:\xampp” directory
            - The php version is 7.3.11 and should preclude compatibility problems with production
            - Navigate to “c:\xampp”, right click on “xampp-control.exe” and run as administrator
                • select upper right corner “config” and Autostart  “Apache” and “MySQL” – then “Save”
                • (if you want them to run as service, check the “Service” box in front of “Apache” and “MySQL” (recommended)
                • The “phpMyAdmin” may be found at “http://localhost/phpmyadmin/”
                • Native “MySQL” my be found at “C:\xampp\mysql\bin\mysql.exe -u root” 
        - Create directory “c:\xampp\htdocs\cgpgoldo”
		
    • Log in to https://cgpgold.org:2083 as ‘cgpgoldo’
        - Navigate to "files" - "file manager" (opens new window)
            - Select the "public_html" directory and “Select All”
            - Deselect “backwpup” and “.htaccess” (don’t need them)
            - select "compress", then select “zip” type – (smaller file)
            - After complete, select the “.well-known.zip” file and download it
                • After download, delete the “.well-known.zip” file 
            - Close the File manager window.
            - Move the downloaded “.well-known.zip” file to “c:\xampp\htdocs\cgpgoldo” directory
            - “Un-zip” “.well-known.zip” to “c:\xampp\htdocs\cgpgoldo” directory
			
        - Navigate to “databases”, “phpMyAdmin” in cPanel
            - Select “cgpgoldo_prod” database
            - Select “Export”  and “Quick - …”, then “Export” 
                • Move the downloaded “cgpgoldo_prod.sql” file to “c:\xampp\htdocs\cgpgoldo” directory 
				
    • Load the database to “MySQL” – in a “cmd” window enter “C:\xampp\mysql\bin\mysql.exe -u root“ and copy and paste the following in the “cmd” window:
	
	
		DROP DATABASE IF EXISTS `cgpgoldo_prod`;
		CREATE DATABASE cgpgoldo_prod COLLATE latin1_swedish_ci;
		DROP user `cgpgoldo_cauprod`@`localhost`;
		CREATE USER `cgpgoldo_cauprod`@`localhost` IDENTIFIED BY '4Gx!X@shZwrV';
		GRANT ALL PRIVILEGES ON *.* TO `cgpgoldo_cauprod`@`localhost` WITH GRANT OPTION;
		GRANT ALL PRIVILEGES ON `cgpgoldo_prod`.* TO `cgpgoldo_cauprod`@`localhost`;
		DROP user `cgpgoldo`@`localhost`;
		CREATE USER `cgpgoldo`@`localhost` IDENTIFIED BY '4Gx!X@shZwrV';
		GRANT ALL PRIVILEGES ON *.* TO `cgpgoldo`@`localhost` WITH GRANT OPTION;
		GRANT ALL PRIVILEGES ON `cgpgoldo_prod`.* TO `cgpgoldo`@`localhost`;
		USE cgpgoldo_prod;
		source C:\xampp\htdocs\cgpgoldo\cgpgoldo_prod.sql

    • If the above worked correctly, we can now update the “caup_options” table to point to the correct website:  (and change the “SMTP” email setting) – copy and paste the following into the “cmd” window:
	
	
		UPDATE caup_options SET option_value = replace(option_value, 'https://cgpgold.org', 'http://localhost/cgpgoldo') WHERE option_name = 'home' OR option_name = 'siteurl';
		UPDATE caup_posts SET post_content = replace(post_content, 'https://cgpgold.org', 'http://localhost/cgpgoldo');
		UPDATE caup_postmeta SET meta_value = replace(meta_value, 'https://cgpgold.org', 'http://localhost/cgpgoldo');
		UPDATE caup_options SET option_value = 'false' where option_name = "cgp_Use_SMTP";

The first thing to do, is to update the “permalinks” – go directly to it using “http://localhost/cgpgoldo/wp-admin/options-permalink.php” – you will need to login, then “Save Changes”.  You are now good to go!

Use  http://localhost/cgpgoldo/ to login to the website.  The Administrator account is “cgpadmin” with Password: fx49wYMo9w   (you should change this on the production side as this password will be available here.)  Also, there is an email account: cgpadmin@cgpgold.org set up with the same password.  This account will forward to your email (see cPanel “emails” to make changes)