FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » What does msg_1 do?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
What does msg_1 do? [message #27705] Wed, 21 September 2005 22:26 Go to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
We have installed fudforum on our server and over time
noticed that msg_1 file grows in size. I have recently
for test purposes copied the file to a different location and
zeroed out the file. In doing so I have notice that the body of previous messages that were sent in various forums were gone.
I still have the old msg_1 file. The purpose of moving the
file was to gain more disk space. Is there a way to fix this
without having to fill my disk.

Report message to a moderator

Re: What does msg_1 do? [message #27707 is a reply to message #27705] Thu, 22 September 2005 13:14 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
That file stores the message bodies, you cannot just remove it Smile

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27715 is a reply to message #27707] Thu, 22 September 2005 17:55 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
I still have the old msg_1,can it move it back. Is there a way of joining the old and new msg_1 file so the bodies will still be there. And also is there a way of compressing the file to save disk space with any problems, if so how?


Thanks

Report message to a moderator

Re: What does msg_1 do? [message #27717 is a reply to message #27715] Thu, 22 September 2005 20:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You cannot compress that file no more then you can compress your MySQL database and have it continue to work.

You can merge but it probably better to keep them separate now, rename the old one to msg_2 and and update old message to have file_id column to have 2 as a value.

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27718 is a reply to message #27717] Thu, 22 September 2005 21:16 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
I moved the old msg_1 file to msg_2 file to the right location
and the bodies are still not appearing. What do you mean
when you say update the old message to have file_id column to have 2 as a value. Are you saying that I should update the fud_msg.tbl or something else.


Thanks

[Updated on: Thu, 22 September 2005 23:15]

Report message to a moderator

Re: What does msg_1 do? [message #27728 is a reply to message #27718] Fri, 23 September 2005 14:20 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The database msg table stored the id of the file to open. So for all old message you need to update that id to # 2.

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27733 is a reply to message #27728] Fri, 23 September 2005 16:21 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
What file do I need to modify inorder to make these
changes? And exactly what field in the file do I change?


Thanks

[Updated on: Fri, 23 September 2005 16:29]

Report message to a moderator

Re: What does msg_1 do? [message #27734 is a reply to message #27733] Fri, 23 September 2005 16:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to modify the message table in the database.

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27735 is a reply to message #27734] Fri, 23 September 2005 16:32 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
Is it the fud_msg.tbl file? if so exactly what fields
in the file need to change to #2?



Thanks

Report message to a moderator

Re: What does msg_1 do? [message #27736 is a reply to message #27735] Fri, 23 September 2005 16:51 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need RUN a database query... y'know UPDATE

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27737 is a reply to message #27736] Fri, 23 September 2005 16:55 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
When I run ./mysql I get this error :
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Report message to a moderator

Re: What does msg_1 do? [message #27740 is a reply to message #27737] Fri, 23 September 2005 20:11 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to provide login password and the database you want to access to that command.

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27744 is a reply to message #27740] Sat, 24 September 2005 01:14 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
Thank you so much for your help!! I was able to retrieve the
messages by updating the message table. I was not able to view any new messages in that table since the messages were lost.
Meaning everything in msg_2 exist in the message table but the new msg_1 doesnot.

Report message to a moderator

Re: What does msg_1 do? [message #27747 is a reply to message #27744] Sat, 24 September 2005 16:10 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you make sure to ONLY update the records referring to the new messages?

FUDforum Core Developer

Report message to a moderator

Re: What does msg_1 do? [message #27787 is a reply to message #27747] Mon, 26 September 2005 17:09 Go to previous message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
I moved the old msg_1 back to the message directory and renamed it to msg_2 then updated the mesage table to change the file_id from 1 to 2 which only contained the old message and not the new messages.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Where I find the variable "{to VAR: r[0 ]}" ?
Next Topic: How to unlock/use this file?
Goto Forum:
  

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

Current Time: Sun Nov 10 08:20:22 GMT 2024

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

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