[Mediawiki-l] When using LOCK TABLES??

[Michael D. Peters]

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/