Setting a WordPress Site Live
- Check domain DNS and nameservers are pointing to the server you are going to use
- Ensure checklist is completed, with second check. Download old site files as a backup if possible.
- Log on to your dev cpanel, and start downloading site files (compress folder, tar.gz).
- Install and activate Search & Replace plugin on dev site. It will ask you to download a backup of the SQL database – Do this and upload it to OneDrive.
- Next tab, insert the domains to search and replace. Select all tables. Export SQL file with changes, with GZIP compression, and download this file – save this in OneDrive also.
- Go to server you wish to use. Account functions > Create new account. Fill out details and log in keepass.
- Go to new site entry through Account info > List accounts.
- Go to MySQL
- Create new database and new user
- Add user to DB with all permissions
- Upload new DB downloaded from search and replace to PHP MyAdmin
- Go to new site file manager, public_html. Upload the tar.gz file of dev files, extract once complete.
- Click settings, tick Show Hidden Files (dotfiles)
- Find .htaccess, right click and edit.
- Change the WordPress section to:
# BEGIN WordPress
# The directives (lines) between “BEGIN WordPress” and “END WordPress” are
# dynamically generated, and should only be modified via WordPress filters.
# Any changes to the directives between these markers will be overwritten.
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule .* – [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
RewriteBase /
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress
- Save changes, close.
- Find wp-config.php, right click, edit.
- Add new Database, Database User and Password to wp-config.php in the following fields:
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘DATABASE_NAME_HERE‘);
/** MySQL database username */
define(‘DB_USER’, ‘DATABASE_USERNAME_HERE‘);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘DATABASE_PASSWORD_HERE‘);
- Go to live site URL and check site is fully working