Re: LOCK TABLES

[mdpeters]

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 <mdpeters@stripped> 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 <mdpeters@stripped> 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 <mdpeters@stripped> 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`
>> >> >> --
>> >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
> Transitional//EN"
>> >> >>    
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>> >> >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"
> lang="en"
>> >> >> dir="ltr">
>> >> >> <head>
>> >> >>     <link rel="icon" href="./favicon.ico"
> type="image/x-icon" />
>> >> >>     <link rel="shortcut icon" href="./favicon.ico"
>> >> >> type="image/x-icon" />
>> >> >>     <title>phpMyAdmin</title>
>> >> >>     <meta http-equiv="Content-Type" content="text/html;
>> >> >> charset=utf-8" />
>> >> >>     <link rel="stylesheet" type="text/css"
>> >> >>
>> >> 
>>
> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&amp;js_frame=right" 
>>
>> >>
>> >> >>
>> >> >> />
>> >> >>     <link rel="stylesheet" type="text/css"
>> >> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721"
>> >> media="print" />
>> >> >>     <script type="text/javascript"
> language="javascript">
>> >> >>     // <![CDATA[
>> >> >>     // Updates the title of the frameset if possible (ns4 does
> not
>> >> allow
>> >> >> this)
>> >> >>     if (typeof(parent.document) != 'undefined' &&
>> >> >> typeof(parent.document) != 'unknown'
>> >> >>         && typeof(parent.document.title) == 'string')
> {
>> >> >>         parent.document.title = 'www.lazarusalliance.com /
>> >> localhost /
>> >> >> horsewiki / archive | phpMyAdmin 2.9.0.2';
>> >> >>
>> >> >>
>> >> >> SQL query:
>> >> >>
>> >> >> -- 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` --
>> >> >> ++++++++
>> >> >>
>> >> >> I have not found a good source to understand what the problem
>> >> might be.
>> >> >> It does not help that I am such a greenhorn with databases 
>> either. I
>> >> >> would appreciate any assistance.
>> >> >>
>> >> >> Michael
>> >> >>
>> >> >> --
>> >> >> MySQL General Mailing List
>> >> >> For list archives: http://lists.mysql.com/mysql
>> >> >> To unsubscribe:
>> >> >> http://lists.mysql.com/mysql?unsub=1
>> >> >>
>> >> >>
>> >>
>> >>
>> >
>>
>>
>