FUDforum: How To » Convert message storage from text to db and reverse

Home » FUDforum » How To » Convert message storage from text to db and reverse

Show: Today's Messages :: Polls :: Message Navigator

Convert message storage from text to db and reverse [message #39568]

Wed, 07 November 2007 14:05

nikademus

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

rick

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.

Attachment: fud_txt2mysql.php
(Size: 2.16KB, Downloaded 820 times)

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

Report message to a moderator

Re: Convert message storage from text to db and reverse [message #40078 is a reply to message #39568]

Fri, 11 January 2008 15:22

Alexey

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

nikademus

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

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) ] [

]

Current Time: Sun Feb 16 16:20:29 GMT 2025

Total time taken to generate the page: 0.02442 seconds