Broken database, for sure (was Wrong database, maybe)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Broken database, for sure (was Wrong database, maybe)

Javier Bezos-2
> When we have had problems it was easier to dump database to sql statements,
> drop database, recreate with media wiki setup with all correct settings and
> restore the data without drop table instructions.

Sounds sensible. Thank you.

Unfortutately, as a consequence of one of their changes, data has
been partially lost (apparently only redirects and a few templates and
images) and I think several tables are corrupted in the sense they
contain data which shouldn't be there, so I'm even considering an
export and then and import (with history, of course) for articles and
the like, and only resort to the database for users (this table seems
ok) and the like (just brainstrorming). <sigh>

Javier

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Broken database, for sure (was Wrong database, maybe)

Dave butlerdi
Another helpful thing may be to create views over your data and use sqlxml
to output as xml and view in an xml visualisation tool. This also makes it
easy to make data changes and then dump data back also via sqlxml or by use
of a xslt sheet to build your insert statements. But at least you can see
the problem visually and find make a plan from there. If unfamiliar with the
db it may help to use sql workbench or whatever and rev engineer structure
into uml or use d2r to export as rdf (it will find table links for you) you
can then visualise in allegrograph gruff or any rdf viewer.

On Fri, Mar 12, 2010 at 11:55 AM, Javier Bezos <[hidden email]> wrote:

> > When we have had problems it was easier to dump database to sql
> statements,
> > drop database, recreate with media wiki setup with all correct settings
> and
> > restore the data without drop table instructions.
>
> Sounds sensible. Thank you.
>
> Unfortutately, as a consequence of one of their changes, data has
> been partially lost (apparently only redirects and a few templates and
> images) and I think several tables are corrupted in the sense they
> contain data which shouldn't be there, so I'm even considering an
> export and then and import (with history, of course) for articles and
> the like, and only resort to the database for users (this table seems
> ok) and the like (just brainstrorming). <sigh>
>
> Javier
>
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>



--
Regards

Dave Butler
butlerdi-at-gmail-dot-com

Also on Skype as butlerdi

Get Skype here http://www.skype.com/download.html


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l