MediaWiki-l November 2006

mediawiki-l@lists.wikimedia.org

147 participants
246 discussions

File storage
by Ingmar Heinrich 09 Nov '06

09 Nov '06

Hi there! Is there a better way, or an extension, to handle uploaded files? The Image upload function doesn't fulfill my needs. It's just too basic. Cheers, Ingmar

1 0

access control on pages
by Sindhu.Subramaniam＠iflexsolutions.com 09 Nov '06

09 Nov '06

Hi, I was just wondering if there is any way to protect access to some pages. I am running mediawiki 1.8.2 MySQL 5.0.27 PHP 5.1.6 I came across some inputs on mentioning the permissions on LocalSettings.php. for example $wgGroupPermissions['group1']['read'] = false; I have given permissions in this manner. I am now getting the group 'group1' in the user rights assignment page. I can also add a user to this page, but the rights are not being enforced. Other than read, I had mentioned, 'cannot create a new page', 'edit' permissions to false. However the user did not face any access problems whatsoever. Please tell me if the methodology I am using is alright. Best regards, Sindhu Subramaniam

2 1

Re: [Mediawiki-l] Deleting a page
by Sindhu.Subramaniam＠iflexsolutions.com 09 Nov '06

09 Nov '06

Best regards, Sindhu Subramaniam -----Original Message----- From: mediawiki-l-bounces(a)Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Sindhu Subramaniam-GA Sent: Wednesday, November 08, 2006 9:19 AM To: mediawiki-l(a)Wikimedia.org Subject: Re: [Mediawiki-l] Deleting a page Thanks a lot Alexis, the 'ALTER TABLE' commands worked. I can delete pages now. Best regards, Sindhu Subramaniam -----Original Message----- From: mediawiki-l-bounces(a)Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.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_move_a_MediaWiki_Database#Troubles hooting _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

1 0

No Images
by Raquel 08 Nov '06

08 Nov '06

This seems really easy, but I just can't make it work. This is two linux servers: Server A and server B are each running Apache and PHP4. On server A, I tarred the wiki installation and, using phpmyadmin, exported the database. On server B, I untarred the wiki installation and, using MySql, created the database, tables and data. Everything seems to be fine except for one thing, images. On server B, the images do not show up. I go through the process of importing them but they don't show up. Going to the directory created, I can see that the image is in the filesystem. Any ideas what may be going on? As far as I know, Apache and PHP4 are configured the same. -- Raquel ============================================================ Doubt 'til thou canst doubt no more...doubt is thought and thought is life. Systems which end doubt are devices for drugging thought. --Albert Guerard

2 3

Rép. : Re: include only a part of a page in another.
by Serveur-Faucon Surveillance 08 Nov '06

08 Nov '06

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#Noinclude_and_includeonly < < >>> JMorgan(a)d2hawkeye.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#Noinclude_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-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l --------------------------------------------------- Alexandre Racine - Gardien Virtuel - Sécurité Informatique www.gardienvirtuel.com Montréal, Québec, Canada

3 2

Subject: MySQL Database Error
by Patricia Barden 08 Nov '06

08 Nov '06

Hello Simon: Yes, we did run the update.php script. Tricia

1 0

LOCK TABLES and MySQL wierdness?
by Michael D. Peters 08 Nov '06

08 Nov '06

I have tried to check the database and this is the output using MyPHPAdmin. It is critical that this database gets moved to a new server as the original server is dying. horsewiki.archive check error Table 'horsewiki.archive' doesn't exist horsewiki.categorylinks check error Table 'horsewiki.categorylinks' doesn't exist horsewiki.externallinks check error Table 'horsewiki.externallinks' doesn't exist horsewiki.hitcounter check note The storage engine for the table doesn't support c... horsewiki.horse_archive check status OK horsewiki.horse_categorylinks check status OK horsewiki.horse_externallinks check status OK horsewiki.horse_filearchive check status OK horsewiki.horse_hitcounter check note The storage engine for the table doesn't support c... horsewiki.horse_image check status OK horsewiki.horse_imagelinks check status OK horsewiki.horse_interwiki check status OK horsewiki.horse_ipblocks check status OK horsewiki.horse_ipblocks_old check status OK horsewiki.horse_job check status OK horsewiki.horse_langlinks check status OK horsewiki.horse_logging check status OK horsewiki.horse_math check status OK horsewiki.horse_objectcache check status OK horsewiki.horse_oldimage check status OK horsewiki.horse_page check status OK horsewiki.horse_pagelinks check status OK horsewiki.horse_querycache check status OK horsewiki.horse_querycache_info check status OK horsewiki.horse_recentchanges check status OK horsewiki.horse_revision check status OK horsewiki.horse_searchindex check warning 1 client is using or hasn't closed the table prope... horsewiki.horse_searchindex check status OK horsewiki.horse_site_stats check status OK horsewiki.horse_templatelinks check status OK horsewiki.horse_text check status OK horsewiki.horse_trackbacks check status OK horsewiki.horse_transcache check status OK horsewiki.horse_user check status OK horsewiki.horse_user_groups check status OK horsewiki.horse_user_newtalk check status OK horsewiki.horse_validate check status OK horsewiki.horse_watchlist check status OK horsewiki.image check error Table 'horsewiki.image' doesn't exist horsewiki.imagelinks check error Table 'horsewiki.imagelinks' doesn't exist horsewiki.interwiki check error Table 'horsewiki.interwiki' doesn't exist horsewiki.ipblocks check error Table 'horsewiki.ipblocks' doesn't exist horsewiki.job check error Table 'horsewiki.job' doesn't exist horsewiki.logging check error Table 'horsewiki.logging' doesn't exist horsewiki.math check error Table 'horsewiki.math' doesn't exist horsewiki.objectcache check error Table 'horsewiki.objectcache' doesn't exist horsewiki.oldimage check error Table 'horsewiki.oldimage' doesn't exist horsewiki.page check error Table 'horsewiki.page' doesn't exist horsewiki.pagelinks check error Table 'horsewiki.pagelinks' doesn't exist horsewiki.querycache check error Table 'horsewiki.querycache' doesn't exist horsewiki.recentchanges check error Table 'horsewiki.recentchanges' doesn't exist horsewiki.revision check error Table 'horsewiki.revision' doesn't exist horsewiki.searchindex check status OK horsewiki.site_stats check error Table 'horsewiki.site_stats' doesn't exist horsewiki.templatelinks check error Table 'horsewiki.templatelinks' doesn't exist horsewiki.text check error Table 'horsewiki.text' doesn't exist horsewiki.trackbacks check error Table 'horsewiki.trackbacks' doesn't exist horsewiki.transcache check error Table 'horsewiki.transcache' doesn't exist horsewiki.user check error Table 'horsewiki.user' doesn't exist horsewiki.user_groups check error Table 'horsewiki.user_groups' doesn't exist horsewiki.user_newtalk check status OK horsewiki.validate check error Table 'horsewiki.validate' doesn't exist horsewiki.watchlist check error Table 'horsewiki.watchlist' doesn't exist #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? mysql> ----------------------------------------- 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://lazarusalliance.com/policy/

1 0

Moving wiki to a new server
by Mike Stief 08 Nov '06

08 Nov '06

Hey, I am moving a wiki to a new server and have run into some problems that I don't quite understand. I migrated the database and then setup the webserver and copied over the web folder. When I went to go to the wiki, everything seemed to work fine; however, when I went to edit a page and then save the page it acts like you tried to preview the page. The save page and show preview now do the same thing. Is there a quick way to fix that problem? Thanks for your help. Mike

1 0

include only a part of a page in another.
by Serveur-Faucon Surveillance 08 Nov '06

08 Nov '06

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. --------------------------------------------------- Alexandre Racine - Gardien Virtuel - Sécurité Informatique www.gardienvirtuel.com Montréal, Québec, Canada

3 2

Re: [Mediawiki-l] MediaWiki-l Digest, Vol 38, Issue 13
by Michael D. Peters 08 Nov '06

08 Nov '06

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.mysql.com/mysql/202700 This is my post about this very issue without success. > http://www.google.com/search?hs=gc&hl=en&lr=&client=firefox- > a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+error+1146&btnG=Search I am not certain if this is my problem. > Send MediaWiki-l mailing list submissions to > mediawiki-l(a)Wikimedia.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-request(a)Wikimedia.org > > You can reach the person managing the list at > mediawiki-l-owner(a)Wikimedia.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.Subramaniam(a)iflexsolutions.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" <SrvFaucon(a)cslaval.qc.ca> > Subject: [Mediawiki-l] R?p. : Re: include only a part of a page in > another. > To: <mediawiki-l(a)Wikimedia.org> > Message-ID: <s550931c.005(a)bp.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#Noinclude_and_includeonly > < > < >>>> JMorgan(a)d2hawkeye.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#Noinclude_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-l(a)Wikimedia.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 <brion(a)pobox.com> > Subject: Re: [Mediawiki-l] mediawiki busts out of frames? > To: MediaWiki announcements and site admin list > <mediawiki-l(a)Wikimedia.org> > Message-ID: <4550DAEA.7080905(a)pobox.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/MediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_… > > -- brion vibber (brion @ pobox.com) > > > ------------------------------ > > Message: 3 > Date: Tue, 7 Nov 2006 20:16:11 +0100 > From: "Arjen Verweij" <arjen.verweij(a)gmail.com> > Subject: Re: [Mediawiki-l] mediawiki busts out of frames? > To: "MediaWiki announcements and site admin list" > <mediawiki-l(a)wikimedia.org> > Message-ID: > <201207d70611071116gc1e7707p263224eb2d1ad5e6(a)mail.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/mediawiki-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 <brion(a)pobox.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/MediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_… >> >> -- brion vibber (brion @ pobox.com) >> _______________________________________________ >> MediaWiki-l mailing list >> MediaWiki-l(a)Wikimedia.org >> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l >> > > > ------------------------------ > > Message: 4 > Date: Tue, 7 Nov 2006 17:26:22 -0300 > From: "Fernando Correia" <fernandoacorreia(a)gmail.com> > Subject: Re: [Mediawiki-l] Problems with MediaWiki on Windows with > Apache :-( > To: "MediaWiki announcements and site admin list" > <mediawiki-l(a)wikimedia.org> > Message-ID: > <8140eff40611071226m79c3fbcdh6627aeba1f635c10(a)mail.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 <xxx@host>"; > $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.Subramaniam(a)iflexsolutions.com> > Subject: Re: [Mediawiki-l] Deleting a page > To: <mediawiki-l(a)Wikimedia.org> > Message-ID: > <AF8C412A3B3396418292A43D613B83DD51E74A(a)MUM-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-bounces(a)Wikimedia.org > [mailto:mediawiki-l-bounces@Wikimedia.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_move_a_MediaWiki_Database#Troubles > hooting > > _______________________________________________ > MediaWiki-l mailing list > MediaWiki-l(a)Wikimedia.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.peters(a)lazarusalliance.com> > Subject: [Mediawiki-l] When using LOCK TABLES?? > To: mediawiki-l(a)Wikimedia.org > Message-ID: > <2181.71.224.6.35.1163001634.squirrel(a)Exchanger.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://lazarusalliance.com/policy/ > > > > ------------------------------ > > Message: 7 > Date: Wed, 08 Nov 2006 18:11:09 +0200 > From: Rotem Liss <rotemliss_net(a)fastmail.fm> > Subject: Re: [Mediawiki-l] When using LOCK TABLES?? > To: MediaWiki announcements and site admin list > <mediawiki-l(a)Wikimedia.org> > Message-ID: <4552019D.1030300(a)fastmail.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/0dU8mcRAmvxAJ4hu5XlVAc2neSDvG0jOUt6j5v8PgCeONjX > LuRJtb8k4eKQ2iTTdaPLFck= > =j363 > -----END PGP SIGNATURE----- > > > ------------------------------ > > Message: 8 > Date: Wed, 8 Nov 2006 11:38:05 -0500 > From: Diona Kidd <diona(a)knowmad.com> > Subject: Re: [Mediawiki-l] When using LOCK TABLES?? > To: MediaWiki announcements and site admin list > <mediawiki-l(a)Wikimedia.org> > Message-ID: <FC009637-3802-49AD-AB6A-5167B628C49D(a)knowmad.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.mysql.com/mysql/202700 > http://www.google.com/search?hs=gc&hl=en&lr=&client=firefox- > a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+error+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://lazarusalliance.com/policy/ >> >> _______________________________________________ >> MediaWiki-l mailing list >> MediaWiki-l(a)Wikimedia.org >> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l > > > > ------------------------------ > > _______________________________________________ > MediaWiki-l mailing list > MediaWiki-l(a)Wikimedia.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://lazarusalliance.com/policy/

2 1

← Newer
1
...
15
16
17
18
19
20
21
...
25
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l November 2006