List:General Discussion« Previous MessageNext Message »
From:mdpeters Date:October 17 2006 12:50pm
Subject:Re: LOCK TABLES
View as plain text  
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" <mdpeters@stripped 
> <mailto:mdpeters@stripped>>
> To: <mysql@stripped <mailto:mysql@stripped>>
> 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&amp;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/mysql?unsub=1
> >
Thread
• LOCK TABLESmdpeters16 Oct
  • Re: LOCK TABLESDan Buettner16 Oct
    • Re: LOCK TABLESmdpeters17 Oct
      • Re: LOCK TABLESDan Buettner17 Oct
        • Re: LOCK TABLESmdpeters17 Oct
          • Re: Re: LOCK TABLESDan Buettner17 Oct
            • Re: LOCK TABLESmdpeters17 Oct
          • RE: LOCK TABLESJerry Schwartz17 Oct
            • Re: LOCK TABLESmdpeters17 Oct
  • Re: LOCK TABLESVisolve DB Team17 Oct
    • Re: LOCK TABLESmdpeters17 Oct