Oracle Challenge - 01

For archival purposes these are the notes I left myself for the Oracle Challenge that I won at my last job. You may find something of interest here. Proceed at your own risk. You have been warned, I have an awesome style. ;-)
Please note that I have censored data that could possibly be relevant still.

----------------------
-- Oracle Challenge --
--    Move Notes    --
----------------------

-> Downloaded NaviCat 
-> Transferred Files via SFTP to PC: /media/LandoServ/CHALLENGE
-> Transferred Files to shared hosting at IX: /sitetomove.com

! Noticed index.php has the broken comment. Change \** to /**..

! Noticed database is set to connect at localhost (127.0.0.1), change to
  the same IP I got the site from. This likely means the database was running
  on the same server and WAS connecting from localhost. IP: 98.xxx.xxx.227

! Could not use NaviCat to connect to MySQL database on old host. It is
  claiming that my host is blocked for some reason or another.
  -> Used phpMyAdmin on their cPanel to connect to the database. ARCHIVED.
   || OR || || OR || || OR || || OR ||
   || OR || || OR || || OR || || OR ||
  -> Customer claimed there was no cPanel. I see a directory for it though 
     and tried it. If this is a mistake and there IS supposed to be no cPanel
     the datbase dump could still be accomplished in the following way:
 -> Log in with SSH and run:
 mysqldump -u webmove_dbusr -p******** webmove_db1 > webmove_db.sql
  ftp lanlost.com
  -> c293793
  -> *************
  -> cd lanlost.com
  -> binary
  -> send webmove_db.sql
  -> exit
 Voila! Go to lanlost.com/webmove_db.sql and grab it. Could also use SFTP but since
 I am going to need to upload it to this location anyway I figured this would work.

! ... \\Find me - No wonder they are leaving. (wp_settings.php)
  -> And in /wp-includes/http.php, line 193

! Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate
 122880 bytes) in /hsphere/local/home/c293793/sitetomove.com/blog/wp-content/plugins
 /wp-pagenavi/core.php on line 107 
  -> Increased memory size to 64mb

-> Moved site to /blog

+ One hour and two minutes later - DONE, almost.

-> Added default wordpress .htaccess file
-> Changed RewriteBase / to RewriteBase /blog/

*** Fixed. ***

! Addendum, XML Feed is borked.
  -> auto_prepend_file = /hsphere/local/home/c293793/sitetomove.com
     wejnswpwhitespacefix.php - (In php.ini, didn't Work)
  -> include_once("wejnswpwhitespacefix.php"); INTO /index.php + comment.
   + Original implementation calls for include not include_once but
        then you get errors about 'redefinition.'
        (http://wejn.org/stuff/wejnswpwhitespacefix.php.html)
  -> LINKS IN XML FEED DON'T WORK ... the permalink structure should be
     /%postname% not /%post_name%. This will fix it.

! WP Super Cache is also broken.
  -> Edited advanced-cache.php, changed (OLD USERNAME) to (NEW USERNAME)
  -> Added WP Super Cache rules to .htaccess 

*** Truly fixed! ***

I won not only by being the first person to turn in a complete solution but for the "Addendum" fixes which were not noticed and were thus seen as extra credit.