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

Home » FUDforum » How To » Convert message storage from text to db and reverse
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Convert message storage from text to db and reverse [message #39568] Wed, 07 November 2007 09:05 Go to next message
nikademus is currently offline  nikademus   Belgium
Messages: 2
Registered: November 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hello,

I have stored all mails in text files till now. But now I would like to migrate to a database storage because, even tough it should be slower, it can be replicated through multiple hosts easily.

The fact is now I have some messages stored in the database and some stored in text files. Is there a way to move messages from text files to database and eventually move messages from database to text files?

Best Regards
Re : Convert message storage from text to db and reverse [message #39787 is a reply to message #39568] Sat, 01 December 2007 00:47 Go to previous messageGo to next message
rick is currently offline  rick   Canada
Messages: 1
Registered: December 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi,

I was in the same situation, I created a simple script to do the job. (text files -> db)

This script if very basic with minimal error handling. It worked well for me, but You should review it carefully before using it, just in case...

Hope it will help you.

[Updated on: Sat, 01 December 2007 01:00]

Report message to a moderator

icon5.gif  Re: Convert message storage from text to db and reverse [message #40078 is a reply to message #39568] Fri, 11 January 2008 10:22 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Russian Federation
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
γΙΤΑΤΑ:

Use Database for message storage:
If enabled, regular and private messages will be stored inside a database. This is not recommended for performance reasons!

In mysql storage to be faster?
Re: Convert message storage from text to db and reverse [message #40079 is a reply to message #39568] Fri, 11 January 2008 11:02 Go to previous message
nikademus is currently offline  nikademus   Belgium
Messages: 2
Registered: November 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
No, it is definitely not faster, but mysql storage can be easily replicated with mysql cluster.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: RDF/RSS by topic title only
Next Topic: Permissions to only show attachments to registered members?
Goto Forum:
  

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

Current Time: Sat Jul 04 10:30:55 EDT 2020

Total time taken to generate the page: 0.01011 seconds