MediaWiki-l Digest, Vol 38, Issue 13

horsewiki.archive and horsewiki_archive are two separate
tables.
> Looks like the dump is failing on your first table,
according to your
> 'show tables' command. Can you dump a another single
table? Can you
> select from the archive table?

I'm far from a DBA. How do I do this?

> I think this is more of a MySQL issue than
MediaWiki...and it appears
> there are other entries for it online.
>
> http://lists.mysq
l.com/mysql/202700

This is my post about this very issue without success.

> http://www.google.com/search?hs=gc&h
l=en&lr=&client=firefox-
>
a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+err
or+1146&btnG=Search

I am not certain if this is my problem.

> Send MediaWiki-l mailing list submissions to
> 	mediawiki-lWikimedia.org
>
> To subscribe or unsubscribe via the World Wide Web,
visit
> 	http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> or, via email, send a message with subject or body
'help' to
> 	mediawiki-l-requestWikimedia.org
>
> You can reach the person managing the list at
> 	mediawiki-l-ownerWikimedia.org
>
> When replying, please edit your Subject line so it is
more specific
> than "Re: Contents of MediaWiki-l digest..."
>
>
> Today's Topics:
>
>    1. R?p. : Re:  include only a part of a page in
another.
>       (Serveur-Faucon Surveillance)
>    2. Re: mediawiki busts out of frames? (Brion Vibber)
>    3. Re: mediawiki busts out of frames? (Arjen
Verweij)
>    4. Re: Problems with MediaWiki on Windows with
Apache :-(
>       (Fernando Correia)
>    5. Re: Deleting a page (Sindhu.Subramaniamiflexsolutions.com)
>    6. When using LOCK TABLES?? (Michael D. Peters)
>    7. Re: When using LOCK TABLES?? (Rotem Liss)
>    8. Re: When using LOCK TABLES?? (Diona Kidd)
>
>
>
------------------------------------------------------------
----------
>
> Message: 1
> Date: Tue, 07 Nov 2006 14:07:16 -0500
> From: "Serveur-Faucon Surveillance"
<SrvFauconcslaval.qc.ca>
> Subject: [Mediawiki-l] R?p. : Re:  include only a part
of a page in
> 	another.
> To: <mediawiki-lWikimedia.org>
> Message-ID: <s550931c.005bp.cslaval.qc.ca>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Actually, these are already found ;)
>
> What I am searching is a way to have a function like
this :
>
> {{if (this page is included) | then put <onlyinclude
tag> | else
> <putnothing>}}
>
> That way, only the text that I want would be included,
and at the same
> time would show when seeing the page directly.
>
> Putting <noinclude> all over a lot of pages is
not really what I am
> looking for.
>
>
> <
> <<I believe you are looking for the
<noinclude> and <includeonly> tags.
> <<See http://en.wikipedia.org/wiki/Help:Template#N
oinclude_and_includeonly
> <
> <
>>>> JMorgand2hawkeye.com 2006-11-07
13:43:48 >>>
>>Hi all,
>>
>>So I am experimenting with page inclusion, but can't
find the perfect
>>solution.
>>
>>I know I can include a full page with this {{:Page
tests no 99}}.
>>
>>I know I can include part of a page by putting in
the "Page tests no
> 99" >page some
"<include></include>" so that only the
not included part
> will be >visible insite the first page.
>>
>>But what I would prefer, is more something like
putting some <from
> here><to >here>, but that would be visible
even when the included page
> is visited. >That's not what the
<onlyinclude></onlyinclude> tags do.
>>
>>So what I was thinking about doing is to put some
kind of condition.
>>
>>{{if (this page is included) | then put
<onlyinclude> | else <put
>>nothing>}}
>>{{if (this page is included) | then put
</onlyinclude> | else <put
>>nothing>}}
>>
>>
>>But I can't find the correct syntax for that. Can
someone help me?
> Thanks.
>
>
>
> I believe you are looking for the <noinclude> and
<includeonly> tags.
> See http://en.wikipedia.org/wiki/Help:Template#N
oinclude_and_includeonly
> -Justin
>
>
> PRIVACY NOTICE
>
> This email and any attachments may be confidential
and/or privileged. Use
> of the information contained in this email by anyone
other than the
> intended recipient is strictly prohibited. If you have
received this email
> in error, please notify the sender by replying to this
message and delete
> this email.
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-lWikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
> ---------------------------------------------------
> Alexandre Racine - Gardien Virtuel - S?curit?
Informatique
> www.gardienvirtuel.com
> Montr?al, Qu?bec, Canada
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 07 Nov 2006 20:13:46 +0100
> From: Brion Vibber <brionpobox.com>
> Subject: Re: [Mediawiki-l] mediawiki busts out of
frames?
> To: MediaWiki announcements and site admin list
> 	<mediawiki-lWikimedia.org>
> Message-ID: <4550DAEA.7080905pobox.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Arjen Verweij wrote:
>> Hello,
>>
>> I'm trying to embed a wiki page inside an existing
site that uses
>> frames.
>> Using target="_self" I was hoping to have
the wiki page load inside the
>> frame. Unfortunately, mediawiki seems to bust out
of the frame, as if
>> target="_top".
>>
>> Does anyone know if this behaviour is due to
mediawiki? If it isn't, I'm
>> sorry for bothering you, but I have next to no
control over the parent
>> page
>> (environment). The alternative is to make the wiki
look exactly like the
>> existing page (integrate existing header and
sidebar) but I'm looking to
>> avoid this.
>
> http://meta.wikimedia.org/wiki/M
ediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_frame_as_part_of_
my_site.2C_but_it_keeps_popping_out_of_the_frame
>
> -- brion vibber (brion  pobox.com)
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 7 Nov 2006 20:16:11 +0100
> From: "Arjen Verweij" <arjen.verweijgmail.com>
> Subject: Re: [Mediawiki-l] mediawiki busts out of
frames?
> To: "MediaWiki announcements and site admin
list"
> 	<mediawiki-lwikimedia.org>
> Message-ID:
> 	<201207d70611071116gc1e7707p263224eb2d1ad5e6mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Thanks, I found you in the past as well in:
> http://mail.wikipedia.org/pipermail/mediawi
ki-l/2004-July/000845.html
>
> Now mediawiki opens in a frame, but in the wrong one
with target="_self".
> I
> guess this is progress though. Thank you for responding
I will read your
> link.
>
> Arjen
>
> 2006/11/7, Brion Vibber <brionpobox.com>:
>>
>> Arjen Verweij wrote:
>> > Hello,
>> >
>> > I'm trying to embed a wiki page inside an
existing site that uses
>> frames.
>> > Using target="_self" I was hoping to
have the wiki page load inside
>> the
>> > frame. Unfortunately, mediawiki seems to bust
out of the frame, as if
>> > target="_top".
>> >
>> > Does anyone know if this behaviour is due to
mediawiki? If it isn't,
>> I'm
>> > sorry for bothering you, but I have next to no
control over the parent
>> page
>> > (environment). The alternative is to make the
wiki look exactly like
>> the
>> > existing page (integrate existing header and
sidebar) but I'm looking
>> to
>> > avoid this.
>>
>>
>> http://meta.wikimedia.org/wiki/M
ediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_frame_as_part_of_
my_site.2C_but_it_keeps_popping_out_of_the_frame
>>
>> -- brion vibber (brion  pobox.com)
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-lWikimedia.org
>> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 7 Nov 2006 17:26:22 -0300
> From: "Fernando Correia"
<fernandoacorreiagmail.com>
> Subject: Re: [Mediawiki-l] Problems with MediaWiki on
Windows with
> 	Apache :-(
> To: "MediaWiki announcements and site admin
list"
> 	<mediawiki-lwikimedia.org>
> Message-ID:
> 	<8140eff40611071226m79c3fbcdh6627aeba1f635c10mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> I also had very similar problems with e-mail and change
notifications on
> Windows, but I was able to sort them out.
>
> I use the PEAR method to send e-mails.
>
> I have some configurations like these:
>
> $wgEnableEmail      = true;
> $wgEnableUserEmail  = true;
> $wgEmergencyContact = "xxx <xxxhost>";
> $wgPasswordSender = $wgEmergencyContact;
> $wgSMTP = array(
>  'host'     => "xxx.com.br",
>  'IDHost'   => "xxx.com.br",
>  'port'     => 25,
>  'auth'     => false,
> );
>
> This line,  'auth'     => false, was important.
Although our mail server
> requires SMTP authentication, it was configure to not
use it for the
> server
> IP. If the parameter was true, even with a valid
username and password,
> I'd
> get email errors.
>
> I think other important parameters are:
>
> $wgEnotifUserTalk = true; # UPO
> $wgEnotifWatchlist = true; # UPO
>
>
> I'm new to MediaWiki so I think I can't help you very
much. All I can say
> is
> that it works for me...
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 8 Nov 2006 09:18:31 +0530
> From: <Sindhu.Subramaniamiflexsolutions.com>
> Subject: Re: [Mediawiki-l] Deleting a page
> To: <mediawiki-lWikimedia.org>
> Message-ID:
> 	<AF8C412A3B3396418292A43D613B83DD51E74AMUM-MSG-01.i-flex.com>
> Content-Type: text/plain;	charset="us-ascii"
>
> Thanks a lot Alexis, the 'ALTER TABLE' commands worked.
I can delete
> pages now.
>
> Best regards,
> Sindhu Subramaniam
>
> -----Original Message-----
> From: mediawiki-l-bouncesWikimedia.org
> [mailto:mediawiki-l-bouncesWikimedia.org] On Behalf Of
Alexis Moinet
> Sent: Tuesday, November 07, 2006 6:40 PM
> To: MediaWiki announcements and site admin list
> Subject: Re: [Mediawiki-l] Deleting a page
>
> http://meta.wikimedia.org/wiki/How_to_mo
ve_a_MediaWiki_Database#Troubles
> hooting
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-lWikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 8 Nov 2006 11:00:34 -0500 (EST)
> From: "Michael D. Peters"
<michael.peterslazarusalliance.com>
> Subject: [Mediawiki-l] When using LOCK TABLES??
> To: mediawiki-lWikimedia.org
> Message-ID:
> 	<2181.71.224.6.35.1163001634.squirrelExchanger.lazarusalliance.com>
> Content-Type: text/plain;charset=iso-8859-1
>
> I would like to relocate my current wiki to another
system. I am not
> having luck moving the database.
>
> I run this command:
>
> # mysqldump --user root --password=password horsewiki
> horsewiki.sql
> mysqldump: Got error: 1146: Table 'horsewiki.archive'
doesn't exist when
> using LOCK TABLES
> #
>
> #mysql -h localhost -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or
g.
> Your MySQL connection id is 6760 to server version:
5.0.20a-max-log
>
> Type 'help;' or 'h' for help. Type 'c' to clear the
buffer.
>
> mysql> use horsewiki
> Database changed
> mysql> show tables;
> +-----------------------+
> | Tables_in_horsewiki   |
> +-----------------------+
> | archive               |
> | categorylinks         |
> | externallinks         |
> | hitcounter            |
> | horse_archive         |
> | horse_categorylinks   |
> | horse_externallinks   |
> | horse_filearchive     |
> | horse_hitcounter      |
> | horse_image           |
> | horse_imagelinks      |
> | horse_interwiki       |
> | horse_ipblocks        |
> | horse_ipblocks_old    |
> | horse_job             |
> | horse_langlinks       |
> | horse_logging         |
> | horse_math            |
> | horse_objectcache     |
> | horse_oldimage        |
> | horse_page            |
> | horse_pagelinks       |
> | horse_querycache      |
> | horse_querycache_info |
> | horse_recentchanges   |
> | horse_revision        |
> | horse_searchindex     |
> | horse_site_stats      |
> | horse_templatelinks   |
> | horse_text            |
> | horse_trackbacks      |
> | horse_transcache      |
> | horse_user            |
> | horse_user_groups     |
> | horse_user_newtalk    |
> | horse_validate        |
> | horse_watchlist       |
> | image                 |
> | imagelinks            |
> | interwiki             |
> | ipblocks              |
> | job                   |
> | logging               |
> | math                  |
> | objectcache           |
> | oldimage              |
> | page                  |
> | pagelinks             |
> | querycache            |
> | recentchanges         |
> | revision              |
> | searchindex           |
> | site_stats            |
> | templatelinks         |
> | text                  |
> | trackbacks            |
> | transcache            |
> | user                  |
> | user_groups           |
> | user_newtalk          |
> | validate              |
> | watchlist             |
> +-----------------------+
> 62 rows in set (0.00 sec)
>
> mysql>
>
> I don't really know if "horsewiki.archive" is
the same thing as
> "horsewiki_archive"?
>
> Anyone have an idea? Maybe another way to move a
database?
> --
> Best regards,
>
> Michael
>
>
> -----------------------------------------
> The information transmitted is intended only for the
person or entity to
> which it is addressed and may contain CONFIDENTIAL
material. If you
> receive this material/information in error, please
contact the sender and
> delete or destroy the material/information.
>
> Lazarus Alliance archives all electronic messages for a
period of three
> years.
>
> http://lazarusalli
ance.com/policy/
>
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 08 Nov 2006 18:11:09 +0200
> From: Rotem Liss <rotemliss_netfastmail.fm>
> Subject: Re: [Mediawiki-l] When using LOCK TABLES??
> To: MediaWiki announcements and site admin list
> 	<mediawiki-lWikimedia.org>
> Message-ID: <4552019D.1030300fastmail.fm>
> Content-Type: text/plain; charset=ISO-8859-1
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Michael D. Peters wrote:
>> I don't really know if
"horsewiki.archive" is the same thing as
>> "horsewiki_archive"?
>>
>
> I think that horsewiki.archive means "the table
archive in the database
> horsewiki", while horsewiki_archive means
"the table horsewiki_archive in
> the
> current database". I don't know how to use
mysqldump, but you may have to
> specify a DB tables prefix instead of a database name.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

>
>
iD8DBQFFUgGdqahN/0dU8mcRAmvxAJ4hu5XlVAc2neSDvG0jOUt6j5v8PgCe
ONjX
> LuRJtb8k4eKQ2iTTdaPLFck=
> =j363
> -----END PGP SIGNATURE-----
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 8 Nov 2006 11:38:05 -0500
> From: Diona Kidd <dionaknowmad.com>
> Subject: Re: [Mediawiki-l] When using LOCK TABLES??
> To: MediaWiki announcements and site admin list
> 	<mediawiki-lWikimedia.org>
> Message-ID:
<FC009637-3802-49AD-AB6A-5167B628C49Dknowmad.com>
> Content-Type:
text/plain;	charset=US-ASCII;	delsp=yes;	format=flowed
>
> horsewiki.archive and horsewiki_archive are two
separate tables.
> Looks like the dump is failing on your first table,
according to your
> 'show tables' command. Can you dump a another single
table? Can you
> select from the archive table?
>
> I think this is more of a MySQL issue than
MediaWiki...and it appears
> there are other entries for it online.
>
> http://lists.mysq
l.com/mysql/202700
> http://www.google.com/search?hs=gc&h
l=en&lr=&client=firefox-
>
a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+err
or+1146&btnG=Search
>
> Diona
> ---------------
> Knowmad Technologies
> http://www.knowmad.com
>
>
>
> On Nov 8, 2006, at 11:00 AM, Michael D. Peters wrote:
>
>> I would like to relocate my current wiki to another
system. I am not
>> having luck moving the database.
>>
>> I run this command:
>>
>> # mysqldump --user root --password=password
horsewiki > horsewiki.sql
>> mysqldump: Got error: 1146: Table
'horsewiki.archive' doesn't exist
>> when
>> using LOCK TABLES
>> #
>>
>> #mysql -h localhost -u root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ;
or g.
>> Your MySQL connection id is 6760 to server version:
5.0.20a-max-log
>>
>> Type 'help;' or 'h' for help. Type 'c' to clear
the buffer.
>>
>> mysql> use horsewiki
>> Database changed
>> mysql> show tables;
>> +-----------------------+
>> | Tables_in_horsewiki   |
>> +-----------------------+
>> | archive               |
>> | categorylinks         |
>> | externallinks         |
>> | hitcounter            |
>> | horse_archive         |
>> | horse_categorylinks   |
>> | horse_externallinks   |
>> | horse_filearchive     |
>> | horse_hitcounter      |
>> | horse_image           |
>> | horse_imagelinks      |
>> | horse_interwiki       |
>> | horse_ipblocks        |
>> | horse_ipblocks_old    |
>> | horse_job             |
>> | horse_langlinks       |
>> | horse_logging         |
>> | horse_math            |
>> | horse_objectcache     |
>> | horse_oldimage        |
>> | horse_page            |
>> | horse_pagelinks       |
>> | horse_querycache      |
>> | horse_querycache_info |
>> | horse_recentchanges   |
>> | horse_revision        |
>> | horse_searchindex     |
>> | horse_site_stats      |
>> | horse_templatelinks   |
>> | horse_text            |
>> | horse_trackbacks      |
>> | horse_transcache      |
>> | horse_user            |
>> | horse_user_groups     |
>> | horse_user_newtalk    |
>> | horse_validate        |
>> | horse_watchlist       |
>> | image                 |
>> | imagelinks            |
>> | interwiki             |
>> | ipblocks              |
>> | job                   |
>> | logging               |
>> | math                  |
>> | objectcache           |
>> | oldimage              |
>> | page                  |
>> | pagelinks             |
>> | querycache            |
>> | recentchanges         |
>> | revision              |
>> | searchindex           |
>> | site_stats            |
>> | templatelinks         |
>> | text                  |
>> | trackbacks            |
>> | transcache            |
>> | user                  |
>> | user_groups           |
>> | user_newtalk          |
>> | validate              |
>> | watchlist             |
>> +-----------------------+
>> 62 rows in set (0.00 sec)
>>
>> mysql>
>>
>> I don't really know if
"horsewiki.archive" is the same thing as
>> "horsewiki_archive"?
>>
>> Anyone have an idea? Maybe another way to move a
database?
>> --
>> Best regards,
>>
>> Michael
>>
>>
>> -----------------------------------------
>> The information transmitted is intended only for
the person or
>> entity to which it is addressed and may contain
CONFIDENTIAL
>> material. If you receive this material/information
in error, please
>> contact the sender and delete or destroy the
material/information.
>>
>> Lazarus Alliance archives all electronic messages
for a period of
>> three years.
>>
>> http://lazarusalli
ance.com/policy/
>>
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-lWikimedia.org
>> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
>
> ------------------------------
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-lWikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> End of MediaWiki-l Digest, Vol 38, Issue 13
> *******************************************
>

-----------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain
CONFIDENTIAL material. If you receive this
material/information in error, please contact the sender and
delete or destroy the material/information.

Lazarus Alliance archives all electronic messages for a
period of three years.

http://lazarusalli
ance.com/policy/

_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

MediaWiki-l Digest, Vol 38, Issue 13

Thread: MediaWiki-l Digest, Vol 38, Issue 13