from:"mdpeters"

Re: LOCK TABLES

2006-10-17 Thread mdpeters

I execute using root permissions. I successfully upgraded mediawiki to 
the latest mediawiki-1.8.2 version for grins. I ran php -cli 
./maintenance/update.php without trouble.



Jerry Schwartz wrote:


I wonder if this is a permissions problem.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341


 


-Original Message-
From: mdpeters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 16, 2006 9:19 PM
To: Dan Buettner
Cc: mysql@lists.mysql.com
Subject: Re: LOCK TABLES

I tried mv archive.frm .archive.frm first. Then I ran
mysqldump again.
It moves past archive and onto another table. I did this 6
times, each
time moving the next one it complained about until I stopped and put
them all back.

Dan Buettner wrote:

   


Try looking in the filesystem for the file(s) called
 


"archive" in the
   


database directory, and move them somewhere else (or if you know you
don't need them, delete them).

If it is/was a MyISAM table, or just an errant file, this
 


should work.
   


If it is/was InnoDB, this will be trickier ...

Dan


On 10/16/06, mdpeters <[EMAIL PROTECTED]> wrote:

 


As you can see, it is clearly showing up but I cannot do anything
with it.

mysql> show tables;
+-+
| Tables_in_horsewiki |
+-+
| archive |
| categorylinks   |
| externallinks   |
| hitcounter  |
| horse_archive   |
| horse_categorylinks |
| horse_externallinks |
| horse_hitcounter|
| horse_image |
| horse_imagelinks|
| horse_interwiki |
| horse_ipblocks  |
| horse_job   |
| horse_logging   |
| horse_math  |
| horse_objectcache   |
| horse_oldimage  |
| horse_page  |
| horse_pagelinks |
| horse_querycache|
| horse_recentchanges |
| horse_revision  |
| horse_searchindex   |
| horse_site_stats|
| horse_templatelinks |
| horse_text  |
| horse_trackbacks|
| horse_transcache|
| horse_user  |
| horse_user_groups   |
| horse_user_newtalk  |
| horse_validate  |
| horse_watchlist |
| image   |
| imagelinks  |
| interwiki   |
| ipblocks|
| job |
| logging |
| math|
| objectcache |
| oldimage|
| page|
| pagelinks   |
| querycache  |
| recentchanges   |
| revision|
| searchindex |
| site_stats  |
| templatelinks   |
| text|
| trackbacks  |
| transcache  |
| user|
| user_groups |
| user_newtalk|
| validate|
| watchlist   |
+-+
58 rows in set (0.00 sec)

mysql> SELECT * FROM archive LIMIT 1;
ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist

mysql> drop table archive;
ERROR 1051 (42S02): Unknown table 'archive'




Dan Buettner wrote:

   


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 <[EMAIL PROTECTED]> 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";>
http://www.w3.org/1999/xhtml";
   


xml:lang=&

Re: LOCK TABLES

2006-10-17 Thread mdpeters


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" <[EMAIL PROTECTED] 
<mailto:[EMAIL PROTECTED]>>

To: mailto:mysql@lists.mysql.com>>
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";>
> http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"
> dir="ltr">
> 
>
>
>phpMyAdmin
>
>> 
href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" 


> />
> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" />
>

Re: LOCK TABLES

2006-10-17 Thread mdpeters


mysqldump --user root --password=password horsewiki > horsewiki.sql



Dan Buettner wrote:


Hmmm, sounds like something's pretty abnormal here.  Any idea what may
have been done here?

I wonder if you could step around this with a call to mysqldump that
doesn't explicitly lock tables ... what is the commad you're running
again?

Dan


On 10/16/06, mdpeters <[EMAIL PROTECTED]> wrote:


I tried mv archive.frm .archive.frm first. Then I ran mysqldump again.
It moves past archive and onto another table. I did this 6 times, each
time moving the next one it complained about until I stopped and put
them all back.

Dan Buettner wrote:

> Try looking in the filesystem for the file(s) called "archive" in the
> database directory, and move them somewhere else (or if you know you
> don't need them, delete them).
>
> If it is/was a MyISAM table, or just an errant file, this should work.
> If it is/was InnoDB, this will be trickier ...
>
> Dan
>
>
> On 10/16/06, mdpeters <[EMAIL PROTECTED]> wrote:
>
>> As you can see, it is clearly showing up but I cannot do anything
>> with it.
>>
>> mysql> show tables;
>> +-+
>> | Tables_in_horsewiki |
>> +-+
>> | archive |
>> | categorylinks   |
>> | externallinks   |
>> | hitcounter  |
>> | horse_archive   |
>> | horse_categorylinks |
>> | horse_externallinks |
>> | horse_hitcounter|
>> | horse_image |
>> | horse_imagelinks|
>> | horse_interwiki |
>> | horse_ipblocks  |
>> | horse_job   |
>> | horse_logging   |
>> | horse_math  |
>> | horse_objectcache   |
>> | horse_oldimage  |
>> | horse_page  |
>> | horse_pagelinks |
>> | horse_querycache|
>> | horse_recentchanges |
>> | horse_revision  |
>> | horse_searchindex   |
>> | horse_site_stats|
>> | horse_templatelinks |
>> | horse_text  |
>> | horse_trackbacks|
>> | horse_transcache|
>> | horse_user  |
>> | horse_user_groups   |
>> | horse_user_newtalk  |
>> | horse_validate  |
>> | horse_watchlist |
>> | image   |
>> | imagelinks  |
>> | interwiki   |
>> | ipblocks|
>> | job |
>> | logging |
>> | math|
>> | objectcache |
>> | oldimage|
>> | page|
>> | pagelinks   |
>> | querycache  |
>> | recentchanges   |
>> | revision|
>> | searchindex |
>> | site_stats  |
>> | templatelinks   |
>> | text|
>> | trackbacks  |
>> | transcache  |
>> | user|
>> | user_groups |
>> | user_newtalk|
>> | validate|
>> | watchlist   |
>> +-+
>> 58 rows in set (0.00 sec)
>>
>> mysql> SELECT * FROM archive LIMIT 1;
>> ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist
>>
>> mysql> drop table archive;
>> ERROR 1051 (42S02): Unknown table 'archive'
>>
>>
>>
>>
>> Dan Buettner wrote:
>>
>> > 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 <[EMAIL PROTECTED]> 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
>

Re: LOCK TABLES

2006-10-16 Thread mdpeters

I tried mv archive.frm .archive.frm first. Then I ran mysqldump again. 
It moves past archive and onto another table. I did this 6 times, each 
time moving the next one it complained about until I stopped and put 
them all back.


Dan Buettner wrote:


Try looking in the filesystem for the file(s) called "archive" in the
database directory, and move them somewhere else (or if you know you
don't need them, delete them).

If it is/was a MyISAM table, or just an errant file, this should work.
If it is/was InnoDB, this will be trickier ...

Dan


On 10/16/06, mdpeters <[EMAIL PROTECTED]> wrote:

As you can see, it is clearly showing up but I cannot do anything 
with it.


mysql> show tables;
+-+
| Tables_in_horsewiki |
+-+
| archive |
| categorylinks   |
| externallinks   |
| hitcounter  |
| horse_archive   |
| horse_categorylinks |
| horse_externallinks |
| horse_hitcounter|
| horse_image |
| horse_imagelinks|
| horse_interwiki |
| horse_ipblocks  |
| horse_job   |
| horse_logging   |
| horse_math  |
| horse_objectcache   |
| horse_oldimage  |
| horse_page  |
| horse_pagelinks |
| horse_querycache|
| horse_recentchanges |
| horse_revision  |
| horse_searchindex   |
| horse_site_stats|
| horse_templatelinks |
| horse_text  |
| horse_trackbacks|
| horse_transcache|
| horse_user  |
| horse_user_groups   |
| horse_user_newtalk  |
| horse_validate  |
| horse_watchlist |
| image   |
| imagelinks  |
| interwiki   |
| ipblocks|
| job |
| logging |
| math|
| objectcache |
| oldimage|
| page|
| pagelinks   |
| querycache  |
| recentchanges   |
| revision|
| searchindex |
| site_stats  |
| templatelinks   |
| text|
| trackbacks  |
| transcache  |
| user|
| user_groups |
| user_newtalk|
| validate|
| watchlist   |
+-+
58 rows in set (0.00 sec)

mysql> SELECT * FROM archive LIMIT 1;
ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist

mysql> drop table archive;
ERROR 1051 (42S02): Unknown table 'archive'




Dan Buettner wrote:

> 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 <[EMAIL PROTECTED]> 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";>
>> http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"
>> dir="ltr">
>> 
>> 
>> > type="image/x-icon" />
>> phpMyAdmin
>> 
>> >> 
href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" 


>>
>> />
>> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" 
media="print" />

>>

Re: LOCK TABLES

2006-10-16 Thread mdpeters


As you can see, it is clearly showing up but I cannot do anything with it.

mysql> show tables;
+-+
| Tables_in_horsewiki |
+-+
| archive |
| categorylinks   |
| externallinks   |
| hitcounter  |
| horse_archive   |
| horse_categorylinks |
| horse_externallinks |
| horse_hitcounter|
| horse_image |
| horse_imagelinks|
| horse_interwiki |
| horse_ipblocks  |
| horse_job   |
| horse_logging   |
| horse_math  |
| horse_objectcache   |
| horse_oldimage  |
| horse_page  |
| horse_pagelinks |
| horse_querycache|
| horse_recentchanges |
| horse_revision  |
| horse_searchindex   |
| horse_site_stats|
| horse_templatelinks |
| horse_text  |
| horse_trackbacks|
| horse_transcache|
| horse_user  |
| horse_user_groups   |
| horse_user_newtalk  |
| horse_validate  |
| horse_watchlist |
| image   |
| imagelinks  |
| interwiki   |
| ipblocks|
| job |
| logging |
| math|
| objectcache |
| oldimage|
| page|
| pagelinks   |
| querycache  |
| recentchanges   |
| revision|
| searchindex |
| site_stats  |
| templatelinks   |
| text|
| trackbacks  |
| transcache  |
| user|
| user_groups |
| user_newtalk|
| validate|
| watchlist   |
+-+
58 rows in set (0.00 sec)

mysql> SELECT * FROM archive LIMIT 1;
ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist

mysql> drop table archive;
ERROR 1051 (42S02): Unknown table 'archive'




Dan Buettner wrote:


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 <[EMAIL PROTECTED]> 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";>
http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"
dir="ltr">


type="image/x-icon" />

phpMyAdmin


href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" 


/>

LOCK TABLES

2006-10-16 Thread mdpeters

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";>
http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en" 
dir="ltr">


   
   
   phpMyAdmin
   
   href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d721&js_frame=right" 
/>
   href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" />

Re: LOCK TABLES

Re: LOCK TABLES

Re: LOCK TABLES

Re: LOCK TABLES

Re: LOCK TABLES

LOCK TABLES

6 matches

Site Navigation

Mail list logo

Footer information