FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Forum move without datadump
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Forum move without datadump [message #37914] Tue, 03 July 2007 22:26 Go to next message
meshe is currently offline  meshe   Canada
Messages: 5
Registered: May 2006
Karma: 0
Junior Member
I'm trying to move a FudForum from a shared hosting provider to a dedicated server. The main reason being that nearly everything in the admin section has quit working due to horrible limitations on the mysql timeouts and such with the shared hosting provider. Due to those limitations I can't do a forum datadump, it just times out with "mysql server has gone away".

That said, I've managed to disable the forum, copy the forum files by ftp and get a database dump from the hosting provider and push these up to the new server. I've updated all the paths to point at the forum's new location, database and server names but attachments don't seem to be working. It seems they are looking at __fud_cache and grabbing the file locations from the old directory paths.

Is there a safe way to delete the cache or update those paths so the attachments will load from the new directory structure? This is the only thing holding me back from the full migration of this forum. After that I can upgrade it.

Forum Version: 2.7.4

Thanks in advance,
meshe
Re: Forum move without datadump [message #37916 is a reply to message #37914] Wed, 04 July 2007 00:01 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You can use the REPLACE() function in mysql to replace the old paths with the new ones.

FUDforum Core Developer
Re: Forum move without datadump [message #37926 is a reply to message #37916] Wed, 04 July 2007 16:56 Go to previous messageGo to next message
meshe is currently offline  meshe   Canada
Messages: 5
Registered: May 2006
Karma: 0
Junior Member
Ilia wrote on Tue, 03 July 2007 20:01

You can use the REPLACE() function in mysql to replace the old paths with the new ones.


Oh, it's in the db portion? That makes things easy, what table if you don't mind me asking.

Thanks,
meshe
Re: Forum move without datadump [message #37935 is a reply to message #37926] Fri, 06 July 2007 00:11 Go to previous message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
fud26_attach table.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: FUDforum 2.6.0 with MySQL 5.0.38 :: Installation Failed
Next Topic: Upgrade: 2.7.3 > 2.7.6 ?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 06:32:15 GMT 2024

Total time taken to generate the page: 0.02826 seconds