From: Date: October 17 2006 12:00pm Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202689 Message-Id: <4534A9BB.90600@lazarusalliance.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit mysqldump --user root --password=password horsewiki > horsewiki.sql Dan Buettner wrote: > 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" /> >> >> >>