Server Move?

[Scott Spain]

I need to move my forum to a new server rather quickly.

I can transfer the database over, no problem. Navicat rules!

Obviously I download all the files from the old server, and upload them to the new server. Update my config file with the new database name, username, and password.

What next? Probably some chmoding to do, right?

[Steve Machol]

That should work. Make sure you update the forum URL in the Admin CP and Members Area if it changed.

[Scott Spain]

Thanks.

Any CHMODing to do?

I'm moving to a Windows server too, if that makes a difference.

[Steve Machol]

Windows doesn't have cchmod. The default permissions should work fine but it's difficult to know for sure because every server can be different.

[Scott Spain]

Great. Thanks.

[Scott Spain]

Hmmmm... Ran into a problem...

[Msg] [Dtf] Get table data for: attachment
[Msg] [Dtf] Start transfer to Target Server: attachment
[Err] [Dtf] 2006 - MySQL server has gone away With statement: INSERT INTO `attachment` VALUES ('27', '1174', '1183384036', '1183384036', 'brochure_ungift_A4_010607_LOWRES.pdf', 0x255044462D312E330D25E2E3CFD30D0A3131392030206F626A3C3C2F4
85B373336203335395D2F4C696E656172697A656420312F4520313736333
5382F4C20313037393830342F4E20...

I think it has something to do with transferring from one version of MySQL to another. The target is on MySQL 5. The source is 4.1.22-standard.

Any ideas?

[RichM]

I am unsure as to what the problem is exactly.

However, the first thing I do when I run into database problems such as these, is run a database repair. It may not work in this case though, but it's good practice to run a database repair first unless you actually know what the problem is.