Godaddy informed me about a month ago that they are upgrading their servers resulting in me having to migrate all my site manually myself. I've finally finished it during a trip to Boston with my wife.
Procedures:
Contacted Godaddy, had them create my new account on new host. They emailed me some basic steps, which are not sufficient and I had to google.
In Godaddy File Manager:
- zipped all the files in chunks. Download them to my PC.
- Backup mysql files, I have two databases, one of which is probably useless (from older backup), WordPress only uses one 1 database. But I backed up both anyway.
- Cancel Old Hosting account via Web Hosting -> Options -> Cancel.
Waited for 1 full day, then new account finally shows nycphantom.com is available under setup.
Uploaded all zipped files. Extract them in Godaddy's File Manager.
Attempted to use the new cPanel's database features (phpMyAdmin) to import my database (first create the exact same database name via MySQL Database Wizard with username/password), Failed due to importing time out. File too large to import (>140MB), even though it may have completed uploading.
So I deleted the database/username I created via the above method. And approach the issue via SSH.
Uploaded my sql file to server.
Enable SSH in cPanel -> SSH ACCESS
Logged into SSH, webhosting ip is the host. Godaddy username/password.
CD to the folder where my uploaded sql file resides.
Typed: mysql -p -u newusername newdatabase < dbname.sql
Where I had to make sure the username matches the godaddy account, I think.
Encountered another problem when loading WP. Followed the error trail and edited wp-config.php in my WP journal folder: I changed the username to godaddy's username and the HOST to localhost, which is the new cPanel standard in Godaddy.
And it works now.