List:General Discussion« Previous MessageNext Message »
From:mdpeters Date:October 17 2006 2:45am
Subject:Re: LOCK TABLES
View as plain text  
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
>>
>>
Thread
• LOCK TABLESmdpeters16 Oct
  • Re: LOCK TABLESDan Buettner16 Oct
    • Re: LOCK TABLESmdpeters17 Oct
      • Re: LOCK TABLESDan Buettner17 Oct
        • Re: LOCK TABLESmdpeters17 Oct
          • Re: Re: LOCK TABLESDan Buettner17 Oct
            • Re: LOCK TABLESmdpeters17 Oct
          • RE: LOCK TABLESJerry Schwartz17 Oct
            • Re: LOCK TABLESmdpeters17 Oct
  • Re: LOCK TABLESVisolve DB Team17 Oct
    • Re: LOCK TABLESmdpeters17 Oct