PDA

View Full Version : mysqldump: Error 2020, HOST won't help..


FightRice.com
04-11-2005, 04:46 AM
I'm getting that error and you can probably guess what table is giving it to me, stupid attachments.

Anyway, i contacted my host who told me to contact IT, who in turn told me to contact someone else, I'm on a shared server right now, which is fine for my loads and all, but i can't back up my databases now because of this.

Is there anyway to exclude that one table while i am backing up with SSH and then back up that table later,

The only way i can think of is to use phpMyadmin but i don't like doing it that way, and it'd be like 6 files to do it anyhow which would be a PITA. Thanks

filburt1
04-11-2005, 05:21 AM
<a href="http://www.jsw4.net/info/list-archives/mysql/04-wk33/msg00130.html" target="_blank">http://www.jsw4.net/info/list-archiv.../msg00130.html</a>

Marco van Herwaarden
04-11-2005, 07:07 AM
A sulution to your problem could be to move your attachments to the filesystem and backup those seperatly.

FightRice.com
04-11-2005, 07:17 AM
A sulution to your problem could be to move your attachments to the filesystem and backup those seperatly.

This seems the best solution for now, But how do i move my attachments to the filesystem?

Marco van Herwaarden
04-11-2005, 07:24 AM
Admincp->Attachments->Attachment Storage Type

FightRice.com
04-11-2005, 07:30 AM
Thank you sir.