As posted previously, two years ago, I botched the moving of this site from one hosting provider to another. Today, I finally cared enough to do something about it. On the off change it may help someone else, I enclose the notes below. I’ll (probably) be back to clean these notes up — more likely if anyone expresses an interest.


Created database through cheapwebmall cPanel

edited wp-config.php for the new database host, name, password
ftp’d up the database backup from the old site

nikto:backup-a94b5 <localuser>$ ftp <remoteuser>@joebear.net
<<login stuff>>
ftp> cd _db_backups
250 OK. Current directory is /_db_backups
ftp> put db295303288_wp_20140411_274.sql
local: db295303288_wp_20140411_274.sql remote: db295303288_wp_20140411_274.sql
227 Entering Passive Mode (97,74,144,87,198,128)
150 Accepted data connection
100% |*****************************************************************************| 20351 KiB 3.01 MiB/s 00:00 ETA
226-File successfully transferred
226 6.830 seconds (measured here), 2.91 Mbytes per second
20839600 bytes sent in 00:18 (1.08 MiB/s)
ftp>

At this point, I could browse the front end of the blog!
However, can’t log into admin:
message at www.joebear.net/blog/wp-admin/ after restore:

Fatal error: Cannot redeclare _relocate_children() (previously declared in /<homedir>/html/JoeBear.net/blog/wp-admin/includes/post.php:876) in/<homedir>/html/JoeBear.net/blog/wp-admin/includes/deprecated.php on line 1187

(http://www.joebear.net/blog/wp-admin/upgrade.php?_wp_http_referer=%2Fblog%2Fwp-admin%2F)

Google turns up
https://wordpress.org/support/topic/wordpress-39-master-list?replies=6
leads me to
https://codex.wordpress.org/FAQ_Troubleshooting#How_to_deactivate_all_plugins_when_not_able_to_access_the_administrative_menus.3F
(deactivate all plugins through phpMyAdmin)
option_name:active_plugins, option_value was

a:10:{i:0;s:19:"akismet/akismet.php";i:1;s:27:"comment-notifier/plugin.php";i:2;s:50:"google-analytics-for-wordpress/googleanalytics.php";i:3;s:19:"jetpack/jetpack.php";i:4;s:37:"twitter-tools/twitter-tools-bitly.php";i:5;s:42:"twitter-tools/twitter-tools-excludecat.php";i:6;s:40:"twitter-tools/twitter-tools-hashtags.php";i:7;s:31:"twitter-tools/twitter-tools.php";i:8;s:36:"wordpress-backup/WordpressBackup.php";i:9;s:29:"wp-db-backup/wp-db-backup.php";}

changed to

a:0:{}

still:

Fatal error: Cannot redeclare _relocate_children() (previously declared in /<homedir>/html/JoeBear.net/blog/wp-admin/includes/post.php:876) in/<homedir>/html/JoeBear.net/blog/wp-admin/includes/deprecated.php on line 1187

Returning to the general wordpress 3.9 troubleshooting page, it looks like I many need to do a manual install

Am I at 3.9?

[<remoteuser>@<server> blog]$ cat wp-includes/version.php
<?php
/**
* The WordPress version string
*
* @global string $wp_version
*/
$wp_version = '3.8.6';

Hmm… maybe partially 3.9 and partially 3.8.6?

Manual update:
https://codex.wordpress.org/Updating_WordPress#Manual_Update
http://wordpress.org/download/

After following steps in above page, and trying to log in to the backend, I got the ‘Database Upgrade Required’ message – which has a big blue button entitled ‘Update WordPress Database’. So I did.

Success!