From: Date: October 17 2006 5:25am Subject: Re: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202684 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hmmm, sounds like something's pretty abnormal here. Any idea what may have been done here? I wonder if you could step around this with a call to mysqldump that doesn't explicitly lock tables ... what is the commad you're running again? Dan On 10/16/06, mdpeters wrote: > I tried mv archive.frm .archive.frm first. Then I ran mysqldump again. > It moves past archive and onto another table. I did this 6 times, each > time moving the next one it complained about until I stopped and put > them all back. > > Dan Buettner wrote: > > > 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" /> > >> >>