k multiple databases with 20 or 30 tables each.
myisamchk is a great deal more easier to use.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 5:00 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
At 16:32 -0
Hi!
On Aug 21, Luc Foisy wrote:
> Thank you Paul.
> whew! So just checking will not do anything to the database, in an case?
yes, but ONLY if you run myisamchk with --read-only flag.
> I am not really caring if it returns the "# users still connected/ or
> table not closed right" warning. I am n
ursday, August 21, 2003 3:08 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
I should qualify my answer, to indicate something that may not apply
to the situation you have in mind.
If you're using myisamchk only to *check* tables, it operates in read-only
f
corrupted...
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:08 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
I should qualify my answer, to indicate something that may not apply
to the situation you have in
; MYSQL-List (E-mail)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in th
esday, August 20, 2003 10:06 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Ye
Luc Foisy unknowingly asked us:
Would anything happen to the database if I ran "myisamchk --silent /usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that n
)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
>Would anything happen to the database if I ran "myisamchk --silent
>/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in the
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in the server's buffers.
Running myisamchk in that case can make the tables *in*cons
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and
ensure that no one is using the tables whi
I got an error while executing myisamchk -rq on compressed table. Here's the
output:
[root@db prod_rel5_1_0]# myisampack buyer
Compressing buyer.MYD: (3687550 records)
- Calculating statistics
- Compressing file
62.69%
Remember to run myisamchk -rq on compressed tables
[root@db prod_rel5_1_0]# m
Hi,
As I'd got not answer, I repost my question ;)
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to res
Hi,
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to restore the valid first 16 K block)
[root@forum] /
13 matches
Mail list logo
