Data recovery

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20797
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Data recovery

Post by RMcGirr83 » Fri Nov 17, 2017 3:27 pm

The tables are inter-connected. Post text is stored in the posts table which is linked to the users table, the topics table, the forum table...etc.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49186
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Data recovery

Post by stevemaury » Fri Nov 17, 2017 4:15 pm

posts table, post_text field, but AFAIK, 3.2.x stores the post_test as longtext.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49186
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Data recovery

Post by stevemaury » Fri Nov 17, 2017 8:17 pm

Export the data from the posts table.

Or:

Code: Select all

SELECT CONVERT(post_text USING utf8) FROM phpbb_posts
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: david63, linkonroser, SynologyRouterRepair, vmNav2 and 78 guests