Fredrik Carlsson [EMAIL PROTECTED] wrote:
I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run
these commands on table1 mysql seems to lock up all other databases, is
it possible to run these things in the background so that other
databases can be accessible.
No.
Daniel Rossi [EMAIL PROTECTED] wrote:
hi i was wondering if there is a way to check for a table type ?
SHOW CREATE TABLE, SHOW TABLE STATUS.
ie i have an authentication class, in some situations it uses innodb and sometimes
its myisam and currently its not autocomitting
--
For
Jean Hagen wrote:
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair
/var/log/mysql/check_tables.log
from the command line, plug in the password at the
At 15:14 -0500 8/4/03, Jean Hagen wrote:
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v
--auto-repair /var/log/mysql/check_tables.log
from the command line, plug in the
At 16:57 -0400 8/4/03, walt wrote:
Jean Hagen wrote:
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair
/var/log/mysql/check_tables.log
from the command line,
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table
Maintenance and Crash Recovery
- Original Message -
From: Sigurd
Matthew McNicol [EMAIL PROTECTED] writes:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
I thought the recommended way was using CHECK/ REPAIR TABLE from
inside mysql for the supported
: Check table wildcard syntax?
Matthew McNicol [EMAIL PROTECTED] writes:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
I thought the recommended way was using CHECK/ REPAIR TABLE from
Hi!
On Jul 29, Sigurd Urdahl wrote:
Matthew McNicol [EMAIL PROTECTED] writes:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
I thought the recommended way was using CHECK/ REPAIR TABLE
At 16:26 +0200 7/29/03, Sigurd Urdahl wrote:
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several databases), and hoped to do something like
mysql CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using
cut'n'paste (or some scritpting)
At 15:53 +0100 7/29/03, Matthew McNicol wrote:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table
Maintenance and Crash Recovery
Check table didn't exist in 3.22
Werner Stuerenburg wrote:
Sorry, I don't understand from the manual how to use this
(running MySQL 3.22.32 on RedHat)
I tried to issue
CHECK TABLE tbl_name
as indicated, but get
mysql CHECK TABLE sessData;
ERROR 1064: parse error near 'CHECK
On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote:
it doesn't work on 3.23.32 either!
Check table didn't exist in 3.22
Werner Stuerenburg wrote:
Sorry, I don't understand from the manual how to use this
(running MySQL 3.22.32 on RedHat)
I tried to issue
3.23.38 does
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikemickaloBlezien
Sent: Saturday, June 30, 2001 4:35 PM
To: [EMAIL PROTECTED]
Cc: Werner Stuerenburg; [EMAIL PROTECTED]
Subject: Re: CHECK TABLE
On Sat, 30 Jun 2001 16
14 matches
Mail list logo