looks like someone has used the wiki to munge the osfaq. its well and truly dead. seems dead on the link table which is where the mysqldump dies.. something is not right with the DB.. lucky i did a dump just yesterday!! shesh. timing.
since the db is munged i cant get a proper access to it to drop all the tables. eesh..
so im working on it... phpmyadmin refuses to connect to the wiki DB.. aaargh... gimme time dagnabbit.
osfaq DB is corrupt or munged
osfaq DB is corrupt or munged
-- Stu --
Re:osfaq DB is corrupt or munged
have fixed it. PITA tho. crappy mysql. bleah.
any info added since yesterday about 14:00 GMT (18th sep). will not be there anymore...
any info added since yesterday about 14:00 GMT (18th sep). will not be there anymore...
-- Stu --
Re:osfaq DB is corrupt or munged
again the DB gt munged. 
agrrrrrrr.
so i restored the dump from the above date.
sorry folks. something is sure funky with mysql...
agrrrrrrr.so i restored the dump from the above date.
sorry folks. something is sure funky with mysql...
-- Stu --
Re:osfaq DB is corrupt or munged
I have a backup from September 20th. If you want it, I can mail it to you, or upload it somewhere when I get home in 10 hours or so.
Any hint on whether it's a bug, vandalism, or unrelated issue?
Any hint on whether it's a bug, vandalism, or unrelated issue?
Every good solution is obvious once you've found it.
Re:osfaq DB is corrupt or munged
OT whats PITAdf wrote: have fixed it. PITA tho. crappy mysql. bleah.
any info added since yesterday about 14:00 GMT (18th sep). will not be there anymore...
Only Human
Re:osfaq DB is corrupt or munged
neo;
pita. pain in the @$$.
solar;
you can mail the backup to me if you like.
the mysql dump/restore is easy. ive never had to 'restore' from the wiki dump mechanism.
im not sure what the problem is. but something is going to town on the 'link' table, which in my db is wiki136_link table. its basically two columns of numbers. both indexed. im leaning to corruption as otherwise youd have to add millions of millions of links to the table to cause it to slowdown BUT mysql wont even do a select * on the table... which is why i think its corrupted rather than spammed....
mysql serves its purpose but ive never really liked it much. such is life! its only a tiny wiki for crying out loud.
pita. pain in the @$$.
solar;
you can mail the backup to me if you like.
the mysql dump/restore is easy. ive never had to 'restore' from the wiki dump mechanism.
im not sure what the problem is. but something is going to town on the 'link' table, which in my db is wiki136_link table. its basically two columns of numbers. both indexed. im leaning to corruption as otherwise youd have to add millions of millions of links to the table to cause it to slowdown BUT mysql wont even do a select * on the table... which is why i think its corrupted rather than spammed....
mysql serves its purpose but ive never really liked it much. such is life! its only a tiny wiki for crying out loud.
-- Stu --
Re:osfaq DB is corrupt or munged
Will do tonight.df wrote:
you can mail the backup to me if you like.
I don't have access to the MySQL, so all I have is the Wiki snapshot. Restoring that is rather easy: Empty all Wiki tables, and unpack the ZIP to the /pgsrc directory of the Wiki. The next visit to the Wiki will load all the pages from /pgsrc and set up the tables.the mysql dump/restore is easy. ive never had to 'restore' from the wiki dump mechanism.
As a nice aside, that allows you to do whatever you want to the MySQL (like, renaming the tables etc.), as the Wiki dump is completely independent from that.
Every good solution is obvious once you've found it.
-
Pype.Clicker
- Member
- Posts: 5964
- Joined: Wed Oct 18, 2006 2:31 am
- Location: In a galaxy, far, far away
- Contact:
Re:osfaq DB is corrupt or munged
seems that a page i recently posted about accelerated GFX cards was lost in the process ... if anyone has a copy of it somewhere ...