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 <[EMAIL PROTECTED]> 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&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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]