No.
Compressed storage format is a read-only format that is generated with
the myisampack tool. See:
http://dev.mysql.com/doc/mysql/en/Compressed_format.html
Jacob Friis <[EMAIL PROTECTED]> wrote:
> Is it possible to append rows to a table packed by myisampack?
>
> Thanks,
> Jac
Jacob Friis wrote:
Is it possible to append rows to a table packed by myisampack?
No, RTFM, "Compressed storage format is a read-only format that is
generated with the myisampack tool."
http://dev.mysql.com/doc/mysql/en/Compressed_format.html
--
MySQL General Mailing List
For list archives: http:
"Rick Robinson" <[EMAIL PROTECTED]> wrote:
> Is the myisampack utility supposed to be included in the 4.1.1 binaries for
> Windows? It's not there - I couldn't find any explicit reference in the doc
> about whether this is deliberate or maybe it was just missed?
You are right, myisampack is missi
On Fri, 31 Aug 2001, Michael Widenius wrote:
> > "mmokrejs" == mmokrejs writes:
>
> mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote:
> mmokrejs> Hi,
> mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was
> mmokrejs> probably too big? I haven't found an
Hi!
> "mmokrejs" == mmokrejs writes:
mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote:
mmokrejs> Hi,
mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was
mmokrejs> probably too big? I haven't found any options that would make myisamchk to
mmokrejs> ask
On Thu, 30 Aug 2001, Michael Widenius wrote:
Hi,
yes this patch *fixes* all of my problems, except one table which is/was
probably too big? I haven't found any options that would make myisamchk to
ask for less memory.
/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
/usr
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
>> >Description:
>> I have on Linux running 3.23.41 the following problem:
>>
>> $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
Sasha> /data/mysql/Aactinomyc
On Wed, 29 Aug 2001, Sasha Pachev wrote:
> On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
> > >Description:
> > I have on Linux running 3.23.41 the following problem:
> >
> > $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
> /data/mysql/Aactinomycetemcomitans/blimps.MYI
> >
On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
> >Description:
> I have on Linux running 3.23.41 the following problem:
>
> $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
/data/mysql/Aactinomycetemcomitans/blimps.MYI
> Compressing /data/mysql/Aactinomycetemcomitans/blimps.M
No
pack is like zipping some thing up. It makes it small but it still needs to
be unzipped to retrieve. There is in real life no advantage to disadvatege
except size of DB.
Hope this help
Simon
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2001 12:54
[root@switch logging]# ls -lh ll*
-rw-r-1 root root 44M Jan 10 17:35 ll.MYD
-rw-rw1 root root 126M Jan 10 17:45 ll.MYI
-rw-r-1 root root 9.7k Jan 10 17:25 ll.frm
[root@switch logging]# myisampack ll
Compressing ll.MYD: (0 records)
- Calc
> :(
>
> copy MYD and frm file to new table name. Copy MYI from wrong
> table to the new table name (oops). myisampack new_table.
> new_table.MYD is now 64 bytes.
I should have made a note: the bad MYI file copied over was for a compressed
table, so myisampack said it was already compressed and s
12 matches
Mail list logo
