Hello.
Have you tried mysql_convert_table_format script?
Spencer Yost [EMAIL PROTECTED] wrote:
I just upgraded a server to MySQL 4.1.4. I was at 4.0.8 - everything
worked perfect at 4.0.8
However, since the upgrade, a few dozen tables in a few older databases are
apparently
I just upgraded a server to MySQL 4.1.4. I was at 4.0.8 - everything
worked perfect at 4.0.8
However, since the upgrade, a few dozen tables in a few older databases are
apparently still in ISAM format. The tables now misbehave when trying to
access them(marked in use, error out, trash the
Hello,
Does anyone out there have a working version of MySQL that supports the ISAM
and MyISAM engines and who might could convert my old database for me?
I'd really appreciate it. Please reply off the list.
Thanks,
Bagus
-Original Message-
From: Bagus [mailto:[EMAIL PROTECTED
: 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-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run
, 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-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run Freebsd 2.2
.
Is there 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:
According to the help message, the --type
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
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
I did try
--type='myisam'
--type='isam'
--type=myisam
--type=isam
--type='MYISAM'
--type=MYISAM
--type='ISAM'
--type=ISAM
All produced identical errors.
Specifying the individual tables didn't change the error note. Any other
ideas?
Is this the right way to go about changing these ISD, ISM
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?
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.
Thanks!
Paul
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 ideas why
:[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 box to migrate a
database off an existing web server. The webserver is running
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
is 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 box
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
update), what
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 during this
conversion someone accessed
On Mon, Dec 03, 2001 at 09:28:11AM -0800, Steve Osborne wrote:
I have an existing database with ISAM tables that I would like to
convert to MyISAM tables. Using phpMyAdmin, I can change the table
type using a drop-down box, however I do not know the repercussions
of the table type
I have an existing database with ISAM tables that I would like to convert to
MyISAM tables. Using phpMyAdmin, I can change the table type using a
drop-down box, however I do not know the repercussions of the table type
conversion.
Any advice,
Steve Osborne
Database Programmer
Chinook
Hi there
I am working on a site where they are using ISAM files, (.ISM .IS1), I
want to know if there is a way of accessing these from MYSQL? From what I
have been able to tell they appear totally differently in comparison to some
of my MYISAM table when I open them in Notepad. Can anyone shed
Message-
From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 7:27 AM
To: [EMAIL PROTECTED]
Subject: ISAM v.s. MYISAM
Hi there
I am working on a site where they are using ISAM files, (.ISM .IS1), I
want to know if there is a way of accessing these from MYSQL
Hi,
I've read some people talking about ISAM and MYISAM table.
I dont understand what are those tables and can anyone explain to
me and the
difference of each table. and also which one has better performance?
Read The Fine Manual, chapter 8: MySQL table types
/ Carsten
--
Carsten H
2001, Teddy A Jasin wrote:
Hi,
I've read some people talking about ISAM and MYISAM table.
I dont understand what are those tables and can anyone explain to me and the
difference of each table. and also which one has better performance
Hi,
I've read some people talking about ISAM and MYISAM table.
I dont understand what are those tables and can anyone explain to me and the
difference of each table. and also which one has better performance?
thanks
Teddy
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
26 matches
Mail list logo