hi
Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL
Server.
use
>SHOW PRIVILEGES;
SHOW PRIVILEGES shows the list of system privileges that the MySQL server
supports. The exact list of privileges depends on the version of your server.
For the global, database, table
Dirk,
Some suggestions.
1. can you still dump the table using mysqldump? Then you can import it
again (with the mysql commandline client), creating a 'fresh' table.
2. make a backup of the index file (.MYI), then throw it away. MySQL
will create a new index for you.
HTH,
Martijn
> -Ori
Hello.
> | eps4.inmail | repair | warning | Can't change size of indexfile, error: 27
As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR TABLE. Use it if
the .MYI index file's header is corrupted. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Dirk Vleugels <[EMA
Hello.
>Apart from this
> brightmail.din_top_spam
> warning : 1 clients is using or hasn't closed the table properly
> status :
After what command have you got the warning? CHECK TABLE shouldn't
produce it:
http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html
"If mysqld is
Hi,
I think you need to have root privileges (ALL) on the
table to run REPAIR TABLE since this is a disaster
recovery sql command. It works only for MyISAM tables
in MySQL. I don't think it is supported for all
tables.
I need it because I got a server with big load that sometimes has db
problem
I think you need to have root privileges (ALL) on the
table to run REPAIR TABLE since this is a disaster
recovery sql command. It works only for MyISAM tables
in MySQL. I don't think it is supported for all
tables.
Logically a repair table command would update, insert,
delete and alter the tables:
up
Bgs wrote:
Does this silence mean that nobody knows?!? :)
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Does this silence mean that nobody knows?!? :)
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Hi!
On Jun 25, Dan Cumpian wrote:
> Is there any harm in using the USE_FRM directive by default whenever
> repairing a table?
Yes.
See http://bugs.mysql.com/4252
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/
php <[EMAIL PROTECTED]> wrote:
>
> @@@ please help me! @@@
>
> mysql> REPAIR TABLE f_ivairus_bodies;
> +++--++
> | Table | Op | Msg_type | Msg_text
At 11:14 -0400 7/24/03, Jeff McKeon wrote:
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
If you have access to the mysqlcheck command-line program, you can
accomplish that with this command:
mysqlcheck --repair db_name
Thanks,
It may or may not help, but if you connect to the database using
MySQLCC, you can highlight all the tables and repair, optimise or check
in one go (in the Windows version at least!).
Gary
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: 24 July 2003 16:15
To: MySQL LI
On Thu, Jul 24, 2003 at 11:14:51AM -0400, Jeff McKeon wrote:
> Is there a way to issue a "REPAIR TABLE table_name" command to all
> tables at once? Something like "REPAIR TABLE *"
No.
However, you could use myisamchk with the server off-line. Then you'd
be able to script it and/or use shell wil
perror 28
Error code 28: No space left on device
tl wrote:
>Hello,
>Please help me.
>
>mysql> repair table none;
>+++--+-+
>| Table | Op | Msg_type | Msg_text|
>+++--+---
tl,
Friday, October 11, 2002, 11:55:41 AM, you wrote:
t> mysql> repair table none;
t> +++--+-+
t> | Table | Op | Msg_type | Msg_text|
t> +++--+-
Hi,
perror 28
Error code 28: No space left on device
Make some space on your hard disk ;)
Regards,
Jocelyn
- Original Message -
From: "tl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 10:55 AM
Subject: Repair TABLE - OPERATION FAILED
> Hello,
> Please
tl,
Friday, September 20, 2002, 11:34:26 AM, you wrote:
t> | |
t> CREATE TABLE `zinutes` (
t> `hid` int(10) unsigned NOT NULL default '0',
t> `tipas` int(10) unsigned NOT NULL default '0',
t> `msg` text NOT NULL,
t> `autorius` varch
At 9/20/2002, you wrote:
>Please help me REPAIR TABLE:
>___
>| |
> CREATE TABLE `zinutes` (
> `hid` int(10) unsigned NOT NULL default '0',
> `tipas` int(10) unsigned NOT NULL defau
Hi
Try
create table tmp_zinutes select * from zinutes;
alter table tmp_zinutes add primary key (id), key hid(hid));
if tmp_zinutes has all rows, then
drop table zinutes;
rename table tmp_zinutes to zinutes;
Be carefull, DO NOT DROP TABLE zinutes unless all data has successfully copied
to tm
Hi,
> The manual
>
> http://www.mysql.com/doc/R/E/REPAIR_TABLE.html
>
> mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does
> not say which is the default. Anyone know?
I think the default might actually be neither.
I think the two options correspond roughly to two options
20 matches
Mail list logo