Mass marking messages as read

[CaptainAwesome]

I did a import from phpbb to vb4 and now i have all my messages showing as unread, and i have a lot of them. I'm probably just going to delete all my old messages and start clean but i was wondering if there was a way i could mark everything as read for all the members. I've identified the column in the pm database, and see 3 values, 0, 1 and 2. What would i need to change that column to so that the messages show as having been read?

I also seem to have double imported the messages.

Is it possible to export the database into something like excel, adjust it accordingly, delete the old info on the server and replace it with what i have?

[Dave]

What kind of messages are we talking about, threads, posts, private messages?

[CaptainAwesome]

Sorry, PM's.

[Dave]

PM is read is defined as 1, so the following query will set all PM's to read:

UPDATE pm SET messageread = 1
Be sure to include your table prefix, in case you have one.

--

I'm not sure about the duplicate PM's. You will have to alter the pm, pmreceipt and pmtext tables to delete the duplicates.

[tbworld]

Is it possible to export the database into something like excel, adjust it accordingly, delete the old info on the server and replace it with what i have?

There are plenty of tools that can manipulate a database, "Sqlyog" for an example.
http://en.wikipedia.org/wiki/Comparison_of_database_tools

I am concerned about the duplication, and what else might be duplicated, besides the PM's.

[CaptainAwesome]

I'm not seeing the duplicate messages in my own account, but the person followed up with the following message:

Sorry, I meant on the left side of the screen, where it reads: "My Messages", it shows;

inbox
sent items
imported saved received messages
imported saved received messages
imported saved sent messages
imported saved sent messages

I'm not seeing that in my account.

I had tried to halt the transfer and restart it, and i guess thats where the problem came from. I'm not seeing anything else duplicated....well, i'm not seeing anything duplicated.