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

Home » FUDforum » FUDforum Installation Issues » Forum move without datadump
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Forum move without datadump [message #37914] Tue, 03 July 2007 18:26 Go to next message
meshe is currently offline  meshe   Canada
Messages: 5
Registered: May 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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] Tue, 03 July 2007 20: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
add to buddy list
ignore all messages by this user
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 12:56 Go to previous messageGo to next message
meshe is currently offline  meshe   Canada
Messages: 5
Registered: May 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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] Thu, 05 July 2007 20:11 Go to previous message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
fud26_attach table.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Fri Jun 22 03:40:47 EDT 2018

Total time taken to generate the page: 0.00746 seconds