| Upload just the messages!? [message #4160] |
Wed, 17 July 2002 03:48  |
 |
james
Messages: 65
Registered: June 2002
Karma: 0
|
Member |
|
|
Hi,
I am the guy whose forums were terribly destroyed due to safe mode issues. Anyways, I managed to manually upload (via PHPMYADMIN) all of my forum info - therefore, users can log back in, the post counts are the same, etc. However, the messages are not there. I don't think that the messages are located in MYSQL. Is there a way for me to upload only the messages???
PS - All of the forums, including their identification numbers, are the exact same as before, if that helps.
|
|
|
|
| Re: Upload just the messages!? [message #4162 is a reply to message #4160] |
Wed, 17 July 2002 11:16  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Messages are stored in 2 files
msg_1 <- normal messages
private <- private messages
Upload those 2 files into the messages directory and you get your messages back.
FUDforum Core Developer
|
|
|
|
| Re: Upload just the messages!? [message #4202 is a reply to message #4162] |
Thu, 18 July 2002 03:15 |
|
james
Messages: 65
Registered: June 2002
Karma: 0
|
Member |
|
|
Thanks, I actually figured that out last night, too. In case anyone has to do what I did, you may want to follow these instructions.
1.) Convert the ) at the end of each line to );
2.) Only go with one category (aka - fud_users) at a time. This will reduce errors and make sure that PHPMYADMIN can handle all the data you send to it.
3.) Verify that the data matches (in rows and columns) the table you are trying to upload to. Since I was uploading 2.0.2 data into version 2.2.3 of the forums, I had to add null data in order to make some tables fit properly.
4.)Don't upload tables that you don't need (I use the default style, so I didn't have to upload that SQL Table)
5.) Empty the tables to which you are about to upload new data. Otherwise PHPMYADMIN will return an error.
6.) Don't run consistency checker until you have uploaded all of the tables you are going to upload, AND the MESSAGE FILES mentioned by prottoss in the post right above this one.
7.) Run consistency checker when you finish.
That worked for me, and it will work for you too. If anyone has problems like I had, I would be glad to help them out, as I am now a seasoned pro in hand-editing SQL data and matching it to tables 
|
|
|
|
| Re: Upload just the messages!? [message #9293 is a reply to message #4202] |
Fri, 21 March 2003 16:18 |
 |
forrie
Messages: 47
Registered: August 2002
Location: Derry, NH
Karma: 0
|
Member |
|
|
I ran into a similar issue; however, I lost my MySQL data.
There were only 2 people who made posts to the forum, and I can pretty much tell who did what; but I'm trying to find a way that I can re-import the data from msg_1.
I posted a request for help, but got no response - I imagine I'm not the only person who ran into this predicament.
[Updated on: Fri, 21 March 2003 16:29] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]