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-l Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
|