phpMyAdmin

From: Date: October 17 2006 12:50pm Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202690 Message-Id: <4534B558.5040902@lazarusalliance.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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" > > 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 > > 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` > > -- > > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > > > dir="ltr"> > > > > > > > > phpMyAdmin > > > > > > href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" > > > /> > > > href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > >