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 :: Polls :: Message Navigator
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 14:05 Go to next message
nikademus is currently offline  nikademus   Belgium
Messages: 2
Registered: November 2007
Karma: 0
Junior Member
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

Report message to a moderator

Re : Convert message storage from text to db and reverse [message #39787 is a reply to message #39568] Sat, 01 December 2007 05:47 Go to previous messageGo to next message
rick is currently offline  rick   Canada
Messages: 1
Registered: December 2007
Karma: 0
Junior Member
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 06: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 15:22 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Russian Federation
Messages: 70
Registered: June 2005
Karma: 0
Member
γΙΤΑΤΑ:

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?

Report message to a moderator

Re: Convert message storage from text to db and reverse [message #40079 is a reply to message #39568] Fri, 11 January 2008 16:02 Go to previous message
nikademus is currently offline  nikademus   Belgium
Messages: 2
Registered: November 2007
Karma: 0
Junior Member
No, it is definitely not faster, but mysql storage can be easily replicated with mysql cluster.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
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: Sun Nov 10 11:45:33 GMT 2024

Total time taken to generate the page: 0.02583 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software