From: Date: October 17 2006 3:19am Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202683 Message-Id: <45342F97.6060408@lazarusalliance.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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" /> >> >>