I tried this first to no avail.
mysqldump --user root --password=password --skip-lock-tables horsewiki >
horsewiki.sql
mysqldump: mysqldump: Couldn't execute 'show create table `archive`':
Table 'horsewiki.archive' doesn't exist (1146)
I'll try the update next.
Visolve DB Team wrote:
Hi
From the analysis of other sources,
The error may be due to:
1. MediaWiki was updated from an older version without updating the
database. so to update the database, you can use either the
maintenance script "maintenance/update.php" via the command line, or
the web installer (rename
LocalSettings.php, then go to the wiki).
2. --opt is enabled by default with mysqldump, and part of what it
does it lock tables. So try the backup without lock tables, by adding
*--skip-lock-tables.*
Thanks
ViSolve DB Team.
----- Original Message -----
From: "mdpeters" <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>
To: <mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>>
Sent: Monday, October 16, 2006 9:14 PM
Subject: LOCK TABLES
>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]
