From: Date: October 17 2006 8:51am Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202687 Message-Id: <00c601c6f1b8$ab45e980$3f0110ac@devco> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C3_01C6F1E6.C2B60A40" ------=_NextPart_000_00C3_01C6F1E6.C2B60A40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 LocalSettings.php, then go to the wiki).=20 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 -----=20 From: "mdpeters" To: 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=20 > another. My database is one that is in production to support the=20 > mediawiki wiki application. This is a Solaris Sparc 10 system using = the=20 > mysql-max-5.0.20a-solaris10-sparc version. My database name is = horsewiki. >=20 > I execute this: > # mysqldump --user root --password=3Dpassword horsewiki > = horsewiki.sql > and get this: > mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist = when=20 > using LOCK TABLES >=20 > I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the=20 > database to an SQL file. When I attempt to import it on the other=20 > system, I get this: > ++++++++ > Error >=20 > There seems to be an error in your SQL query. The MySQL server error=20 > output below, if there is any, may also help you in diagnosing the = problem >=20 > ERROR: Unknown Punctuation String @ 494 > STR: /> > SQL: -- phpMyAdmin SQL Dump > -- version 2.9.0.2 > -- http://www.phpmyadmin.net > --=20 > -- Host: localhost > -- Generation Time: Oct 16, 2006 at 10:00 AM > -- Server version: 5.0.20 > -- PHP Version: 5.1.6 > --=20 > -- Database: `horsewiki` > --=20 > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > dir=3D"ltr"> > > > > phpMyAdmin > > = href=3D"./css/phpmyadmin.css.php?token=3D7c73a56802fc2e39fe41180d721&= js_frame=3Dright"=20 > /> > href=3D"./css/print.css?token=3D7c73a56802fc2ee8b4239fe721" = media=3D"print" /> >