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
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 --
s ... 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 a
) 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
tion 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 datab
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: