I execute using root permissions. I successfully upgraded mediawiki to
the latest mediawiki-1.8.2 version for grins. I ran php -cli
./maintenance/update.php without trouble.
Jerry Schwartz wrote:
I wonder if this is a permissions problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-----Original Message-----
From: mdpeters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 16, 2006 9:19 PM
To: Dan Buettner
Cc: mysql@lists.mysql.com
Subject: Re: LOCK TABLES
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 <[EMAIL PROTECTED]> 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 <[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=7c73a56802fc2e39fe41180d7
21&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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
