pegasusict/plat_wordpresstools

This toolset is aimed at making it easier to install & maintain WordPress websites, both on public hosting as well as local development servers. This is a sub project of PLAT.

plat_wordpresstools's Issues

WordPress Migration Script

luckily, our hosting provider has ssh access, so automating the moving of a WP-powered website is feasible.

Procedure:

• Copy all files from the old to the new (sub)domain etc
• Update DB:

UPDATE wp_options SET option_value = 'http://NEW_URL' WHERE wp_options.option_name = 'siteurl';
UPDATE wp_options SET option_value = 'http://NEW_URL' WHERE wp_options.option_name = 'home';

---

new code to check:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

---

check other records in database for vhost uri's

• Export DB and import on the new DB-server if necessary
• new database host/user/DB/pass in wp-config.php of the new site.
• As soon as the DNS for the new site is working, rename dir of old hosting to *.bak or delete and create new dir with same name
• to incorporate for out of date google results, old bookmarks etc, create index.php with the following code:

header("Location: http://NEW_URL/", true, 301);
exit;

WP installation functionality

I'm constructing a script to install WP on a site and perform all the basic setup, DB config, etc

planned functionality:

• single/multiple sites at once?
• select location: local/remote
• webserver type: apache/nginx/caddy
• remote access: ftp/ssh
• generate certificates & auto update certs
• setup DB & DBuser(s)