From: Date: October 17 2006 2:50am Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202682 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Try looking in the filesystem for the file(s) called "archive" in the database directory, and move them somewhere else (or if you know you don't need them, delete them). If it is/was a MyISAM table, or just an errant file, this should work. If it is/was InnoDB, this will be trickier ... Dan On 10/16/06, mdpeters wrote: > As you can see, it is clearly showing up but I cannot do anything with it. > > mysql> show tables; > +---------------------+ > | Tables_in_horsewiki | > +---------------------+ > | archive | > | categorylinks | > | externallinks | > | hitcounter | > | horse_archive | > | horse_categorylinks | > | horse_externallinks | > | horse_hitcounter | > | horse_image | > | horse_imagelinks | > | horse_interwiki | > | horse_ipblocks | > | horse_job | > | horse_logging | > | horse_math | > | horse_objectcache | > | horse_oldimage | > | horse_page | > | horse_pagelinks | > | horse_querycache | > | 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 | > +---------------------+ > 58 rows in set (0.00 sec) > > mysql> SELECT * FROM archive LIMIT 1; > ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist > > mysql> drop table archive; > ERROR 1051 (42S02): Unknown table 'archive' > > > > > Dan Buettner wrote: > > > Michael, is the 'archive' table present in your database? e.g., if > > you do a 'LIST TABLES', does it show up? What happens if you do a > > "SELECT * FROM archive LIMIT 1" ? > > > > I'd hazard a guess that you may have a table definition file with no > > actual table data files, if you're on MyISAM tables. > > > > If you don't need the archive table, can you DROP it successfully? > > > > Dan > > > > > > On 10/16/06, mdpeters wrote: > > > >> I am having a devil of a time moving a database from one server to > >> another. My database is one that is in production to support the > >> mediawiki wiki application. This is a Solaris Sparc 10 system using the > >> mysql-max-5.0.20a-solaris10-sparc version. My database name is > >> horsewiki. > >> > >> I execute this: > >> # mysqldump --user root --password=password horsewiki > horsewiki.sql > >> and get this: > >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when > >> using LOCK TABLES > >> > >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > >> database to an SQL file. When I attempt to import it on the other > >> system, I get this: > >> ++++++++ > >> Error > >> > >> There seems to be an error in your SQL query. The MySQL server error > >> output below, if there is any, may also help you in diagnosing the > >> problem > >> > >> ERROR: Unknown Punctuation String @ 494 > >> STR: /> > >> SQL: -- phpMyAdmin SQL Dump > >> -- version 2.9.0.2 > >> -- http://www.phpmyadmin.net > >> -- > >> -- Host: localhost > >> -- Generation Time: Oct 16, 2006 at 10:00 AM > >> -- Server version: 5.0.20 > >> -- PHP Version: 5.1.6 > >> -- > >> -- Database: `horsewiki` > >> -- > >> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > >> >> dir="ltr"> > >> > >> > >> >> type="image/x-icon" /> > >> phpMyAdmin > >> > >> >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" > >> > >> /> > >> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > >>