This is the guide that i use (hence why I threw it on the forum ;)). I would totally recommend only using hosts with CLI access as it makes certain tasks much easier (backing up with tar, utilizing the mysqldump command, etc).

That error occours becasue you're reaching your space limit (see Disk limit reached), you can't write after you reach your limit.

Most hosts "secure" the mysql server by not allowing external (off site) connections, otherwise i'd tell you to use sqlyog (as i believe it will allow you to dump all data to your local machine). The backup utility in the forum will also reach this space limit, so no use recommending that... You may contact your host, and ask if they could dump the sql database for you as you reach this limit, a lot of them will actually be helpful for "backups".

As for recommending a host, I only really recommend VPS for larger sites, and in that I recommend http://www.webintellects.com

Not easy to debug, but wonder if you could run that stuff from CRON job on hosts that don't allow SSH.

If they allow you access to cron, i don't see why it wouldn't work... most webhosts that don't give you cli access though likely don't give you access to cron either

Well not sure - I've been on a few Linux hosts that did not have or charged extra for SSH but they do have CRON (via Web interface)

FTP up what you want to do then let CRON do it

Yeh, cron can be a really useful tool; in fact I use it to run backups on the 1 site I don't host myself that I own...

Thanks Gizmo, for the GREAT guide to get me started with the transfer! One note for you to possibly include in future editions of your guide: When the SQL and Web servers are different, the --host= command can be added to the mysqldump command (e.g. mysqldump --host=mysql.serverhost.tld -uusername -ppassword my_database_name > my_database_name.sql).

It worked! Yay! Thanks again, Gizmo!!!

I just updated both SQL sections with:
(Note that you can optionally use the -hhostname and -Pport trigger should you be communicating with a non-local SQL server; please note that most servers do not allow non-local access.)

I just followed the instructions to move a copy of my site to a testing site, and all I get is a blank page when I try to bring up the site. No errors or anything, just a blank page. I did the sql dump, and imported it into a new database. Any suggestions?

Thanks,
Ian

Did you set the information in your includes/config.inc.php?