Choose Your Theme
Warren Shea

(Almost) all my sites are migrated!

Friday, February 22nd, 2013 at 12:25 am

(mt) = Media Temple

Decided to combine everything into one compact email for reference purposes. I may need to remember the stuff I’ve done here…so good to document it all.

horderockcafe.com
Migrated domain to (mt), migrated content to (mt), changed nameservers to (mt), recoded to PHP

warrenshea.com
Migrated domain (pending due to domain transfer lockout), migrated content to (mt), changed nameservers to (mt)

seasaltfishandchips.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)

kotobishoujo.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)
kotobishoujo.com Post Migration: many pages didn’t work due to how my 404/permalinks is set up.
Thankfully, I made my own post: Tutorial: Setting up WordPress permalinks without index.php on IIS server which reminded me what I had done. I had to replicate my changes but rather than use IIS/CMS, I used the .htaccess file
# BEGIN WordPress

RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

# END WordPress

worldofwarren.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)

mySQL Backup
For all backup purposes, I used phpMyAdmin to back up the SQL to a .sql file.
To restore the file, I used BigDump which is a script that runs your .sql file (because you can’t upload a .sql file over 10MB) and creates everything. I did run into an error: It failed due to 3000+ lines of commands. To fix this, I simply changed
define (‘MAX_QUERY_LINES’,300);
to
define (‘MAX_QUERY_LINES’,999999);
Not sure if that’s the “best” way to fix it, but it worked. So I’m happy!

And I wrote all this for next time…so I remember :)

Hopefully the migration went well. I still have to test/debug and check everything. Probably be a couple days of fixing things…

Leave a Reply