RE: isam to myisam

2005-01-24 Thread Bagus
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: isam to myisam

2005-01-22 Thread Bagus
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

RE: isam to myisam

2005-01-22 Thread Paul DuBois
- 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

RE: isam to myisam

2005-01-22 Thread Bagus
> -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

RE: isam to myisam

2005-01-20 Thread Bagus
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

Re: isam to myisam

2005-01-20 Thread Paul DuBois
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

Re: ISAM to MyISAM Convert pls

2005-01-04 Thread Gleb Paharenko
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

Re: ISAM to MYISAM

2001-01-15 Thread Dan Nelson
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

Re: ISAM to MYISAM

2001-01-15 Thread Mikel King
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

Re: ISAM to MYISAM

2001-01-15 Thread skip
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