Page 5 of 6
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Thu Aug 11, 2011 7:53 am
by HermanHiddema
Any updates on this?
Can someone at the very least publish the raw database dump?
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Thu Aug 11, 2011 1:39 pm
by Jordus
SpongeBob wrote:Out of curiosity: How can the database be corrupt? Software error in VBulletin software? Hardware problem with database server?
It is a known issue with the vbulletin software.
HermanHiddema wrote:Any updates on this?
Can someone at the very least publish the raw database dump?
If you think you might be able to extract the info then pm me for the link to download it.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Fri Sep 16, 2011 9:50 pm
by xed_over
Either the datadump is incomplete, or some data has been lost due to corruption? Or are some of these count mismatches due to deleted posts or something similar?
for u in user_id.list; do mysql -e "select count(*) from vb_post where userid = "$u";"; done
Code: Select all
userid gd * db
posts count
---------------------
129 3513 3464
221 3005 3008
156 2845 2791
2111 2705 2560
241 2587 2498
155 2428 2435
119 2308 2315
105 2173 2169
670 2067 2044
162 1708 1668
*GoDiscussions post counts as of today
http://www.godiscussions.com/forum/memb ... osts&pp=30
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Fri Sep 30, 2011 5:47 am
by flOvermind
In IPBoard this mismatch would be normal. The "post count" column in the user table increases whenever a post is made, but it never decreases, even when posts are deleted. This can for example be seen as a mismatch between the post count in the user list and the post count on the user profile page.
I wouldn't be surprised when there is a similar thing going on in vBulletin.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Fri Sep 30, 2011 7:53 am
by jts
Huh. But some people have a higher number in the left column and some have a higher number in the right column.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sat Oct 01, 2011 5:12 am
by flOvermind
Yes, I see the same on my IPBoard forum. And I have no idea how that can ever happen...
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 4:23 am
by Lictor
I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 8:08 am
by xed_over
Lictor wrote:I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
the mysql dump was corrupted and incomplete
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 10:09 am
by Bantari
flOvermind wrote:Yes, I see the same on my IPBoard forum. And I have no idea how that can ever happen...
Some people have drafts saved which never got published?
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 11:24 am
by Lictor
xed_over wrote:Lictor wrote:I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
the mysql dump was corrupted and incomplete
It seems a backup failure. MYSQL have many different functions for proper backup for different CMS softwares.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 1:29 pm
by xed_over
Lictor wrote:xed_over wrote:Lictor wrote:I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
the mysql dump was corrupted and incomplete
It seems a backup failure. MYSQL have many different functions for proper backup for different CMS softwares.
either that, or the database itself became corrupted during use, and the latest backup successfully replaced a good previous backup with the now corrupted backup, and no one noticed or saved any previously good backups.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 1:33 pm
by xed_over
Lictor wrote:I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
yeah, I thought the very same thing myself.
but when I finally did see it.. its beyond repair. almost half the tables are missing.
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Sun Sep 15, 2013 1:52 pm
by Lictor
xed_over wrote:Lictor wrote:I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it
yeah, I thought the very same thing myself.
but when I finally did see it.. its beyond repair. almost half the tables are missing.
It's still depends on which tables are missing. If not specific ones still could be repairable from a vanilla setup. (With combine missing tables)
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Fri Jan 16, 2015 10:43 am
by jug
Jordus wrote:HermanHiddema wrote:Can someone at the very least publish the raw database dump?
If you think you might be able to extract the info then pm me for the link to download it.
I'm interested in the old GoDiscussion-forums. Can someone send me a link to the data of the old GoDiscussion-forums, where I can download the db-dump please?
(Have contacted Jordus 5 days ago but without any response yet).
Re: Don making sure GD posts preserved; "fully supports" L19
Posted: Fri Jan 16, 2015 11:57 am
by xed_over
there is no link to the dump.
I have a copy. Its incomplete. about half of the tables are missing.