MHD wrote:Seems to be working Gary...
Good stuff... was moving over the DB hard?
Scott,
The major issue is simply the size of the database. Depending upon how I wxport it, the message text table, on its own, is in excess of 40MB (min), but might be three times that size if you export it as a full SQL script.
You can take some shortcuts in how you export the script, but that creates issues when you're uploading, as the file/packet/query size cannot be too big.
There's about 8 tables in total that become large enough to be affected by this, and they require a fair bit of hand-holding in order to get them loaded.
But the tools available at DreamHost to help this process along are far better than those at NoDaddy, which only provides PHPMyAdmin. While that's ok, I am able to connect directly from my desktop to the SQL here, and could, if I wanted, backup the database directly to my server. That's nice, and there seem to be a few other niceties there as well.
FWIW and regarding the problems we experienced, here's a part of a note from NoDaddy that I recieved this morning.
The issue with your MySQL database was resolved this morning at approximately 9:30 am Mountain Standard Time. We note that you are already aware of this as you have posted to your site at 3:12 am and we spoke at 1:30am your time.
The issue was caused by a deployment and was rolled back, but there was an issue remaining on the server your database resides on. This has since been corrected with the information we provided to our development team.