List:General Discussion« Previous MessageNext Message »
From:mdpeters Date:October 16 2006 5:44pm
Subject:LOCK TABLES
View as plain text  
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
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