import/export of attachments

[ober]

All I'm trying to do is move the database from one server to another. Because you jackasses decided it was a good idea to put the attachments in the database, I can't get phpmyadmin to import the data correctly. It keeps crapping out on the import when it gets to the attachment table.

Can you PLEASE suggest a way around this??

[Floris]

Hello,

Please refrain from profanity. Asking for support while swearing at support doesn't help your issue at all. I understand your frustration, but please keep it nice.

That said, if your hosting provider doesn't provide you with enough freedom in the PHP/MySQL settings to import a big .sql dump through phpmyadmin I recommend asking them for shell access or to increase these values. Or perhaps ask them to import it for you.

If you wish to move the data from host A to B, you could also (as this is a feature in vBulletin btw) export the attachments out of the database into the file system. Then move your forum files and attachments files and database to the new host and restore the database and set the attachments up properly per new hosting account details.

Good luck with moving your forum.