L PROTECTED]
> Sent: Saturday, January 22, 2005 10:48 PM
> To: mysql@lists.mysql.com
> Subject: RE: isam to myisam
>
>
> SHOW ENGINES says no support for ISAM.
>
> So that explains it. Which other server would you suggest I try
> installing? Do you mean I should try in
re an alternative?
Thanks,
Bagus
(ugh)
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 22, 2005 7:46 PM
> To: Bagus; mysql@lists.mysql.com
> Subject: RE: isam to myisam
>
>
> At 19:41 -0600 1/22/05, Bagus wrote:
> &g
-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 20, 2005 10:58 PM
To: Bagus; mysql@lists.mysql.com
Subject: Re: isam to myisam
At 22:46 -0600 1/20/05, Bagus wrote:
>Hi there,
>
>I'm running Freebsd 5.3 and just installed
>mysql-standard-4.1.9-unknown-freebs
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 20, 2005 10:58 PM
> To: Bagus; mysql@lists.mysql.com
> Subject: Re: isam to myisam
>
>
> At 22:46 -0600 1/20/05, Bagus wrote:
> >Hi there,
> >
> >I'm ru
y 20, 2005 10:58 PM
> To: Bagus; mysql@lists.mysql.com
> Subject: Re: isam to myisam
>
>
> At 22:46 -0600 1/20/05, Bagus wrote:
> >Hi there,
> >
> >I'm running Freebsd 5.3 and just installed
> >mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able t
At 22:46 -0600 1/20/05, Bagus wrote:
Hi there,
I'm running Freebsd 5.3 and just installed
mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run Freebsd 2.2 and I think it was mysql 3.21.33b...
I'm not sure. My old system faded away rather abruptly and I
Hi there,
I'm running Freebsd 5.3 and just installed
mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run Freebsd 2.2 and I think it was mysql 3.21.33b...
I'm not sure. My old system faded away rather abruptly and I didn't get a
chance to do database b
Hello.
As of MySQL 4.1, ISAM support is included in the source but not enabled in
binary distributions.
[EMAIL PROTECTED] wrote:
> hello
> i hope im correct here
> i have a problem, after upgrade 4.1 from 4.0 one table is away (index)
> i have table.ISM,.frm and .ISD.
> when i try to
hello
i hope im correct here
i have a problem, after upgrade 4.1 from 4.0 one table is away (index)
i have table.ISM,.frm and .ISD.
when i try to convert it with ALTER TABLE table TYPE = MYISAM;
he only says did not found table.MYI
(where table is my name of the table)
how i can convert it to MYI?
Hey everyone. I figured it out.
Packed tables are read only.
Thanks!
Paul
-Original Message-
From: Paul Borghese [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 9:26 PM
To: [EMAIL PROTECTED]
Subject: Upgrade from ISAM to MyISAM fails with "read only" error
Any
Any ideas why the following upgrade from ISAM to MyISAM fails:
mysql> alter table users type = MYISAM;
ERROR 1036: Table 'users' is read only
This only occurs for about half the tables I tried to upgrade.
>
> -Original Message-
> From: Henry Hank [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 3:37 PM
> To: [EMAIL PROTECTED]
> Subject: question about converting isam to myisam tables (shotcut!)
>
> Hello all,
>
> I'm in the process of build
valid as well.
David
-Original Message-
From: Henry Hank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:37 PM
To: [EMAIL PROTECTED]
Subject: question about converting isam to myisam tables (shotcut!)
Hello all,
I'm in the process of building a new mysql db server b
Hello all,
I'm in the process of building a new mysql db server box to migrate a
database off an existing web server. The webserver is running mysql 3.22.29,
and the new box is running 3.23. The two biggest tables are about 20 million
records and the data and index files are each just over 1
On Thu, Mar 07, 2002 at 12:08:29AM -0500, Mr. Ozette Brown wrote:
>
> I'm in the process of converting all of my database tables from ISAM
> to MYISAM table format. I'll run the mysql_convert_table_format
> script which basically does an "Alter table". If
I'm in the process of converting all of my database tables from ISAM to
MYISAM table format. I'll run the mysql_convert_table_format script
which basically does an "Alter table". If during this conversion
someone accessed a web page which writes to the database (insert or
In the last episode (Jan 15), Aaron Schlesinger said:
> I've noticed that most of the really cool new features in MySQL use
> myisam tables. My tables are from an earlier version, and are only
> ISAM.
>
> 2 Questions:
>
> 1) How do you convert the tables?
Run mysql_convert_table_format, which w
Aaron,
I sugest that you use this app,
http://www.ocsny.com/main/index.ocs?url=mysqlbackup and then use the dumped
files on the new server to rebuild you db you could quite conceivably br up
within 2 hours...
Cheers,
Mikel
Aaron Schlesinger wrote:
> I've noticed that most of the reall
I've just done this myself, and had no problems whatsoever. I upgraded
from 3.22 to 3.23...
1. Compile mysql 3.23
2. Shutdown mysql 3.22 server
3. (Carefully) do a make install of 3.23, ensuring your data files in
~mysql/var are not over-written
4. Restart mysql server (3.23)
5. Go through each t
I've noticed that most of the really cool new features in MySQL use myisam
tables. My tables are from an earlier version, and are only ISAM.
2 Questions:
1) How do you convert the tables?
2) Will my data be changed or corrupted by doing #1?
Aaron
-
20 matches
Mail list logo
