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]> To: <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] >
