From: Date: October 16 2006 8:25pm Subject: Re: LOCK TABLES List-Archive: http://lists.mysql.com/mysql/202669 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 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` > -- > "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" /> >