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
>
>
--
F
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,
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 p
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 passw
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
That'l
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)
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 CHEC
"Matthew McNicol" <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 4:04 PM
Subject: Re: Check table wildcard syntax?
> "Matthew McNicol" <[EMAIL PROTECTED]> writes:
>
> > The recommended way to quickly check all tables is:
> >
> > myisamchk --s
"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 b
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 Urd
3.23.38 does
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikeBlezien
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:34:06
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 tr
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 ne
14 matches
Mail list logo
