Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
> > > Brian J.S. Miller wrote: > >> >>Walt, >> >>The tables are ISAM type. These are some seriously old tables >> (originally >>from version 3.21) and were never updated to type MyISAM. Despite >>frequent updates to mysqld. >> >>There is a program isamchk which is similar to myisamchk, but it ret

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread gerald_clark
Brian J.S. Miller wrote: Walt, The tables are ISAM type. These are some seriously old tables (originally from version 3.21) and were never updated to type MyISAM. Despite frequent updates to mysqld. There is a program isamchk which is similar to myisamchk, but it returns the error "___ is not a

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
ields in table 'admin_privs'" (or whatever the table name is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: &

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
t;>exaple). >> >>Here is what I have tried already: >>1) backing down to Mysql 3.23 >>2) Running 2.6 kernel (read that ISAMs aren't binary compatible across >>OS/platform) >>3) CHECK TABLE admin_privs (says: "Incorrect information in file: >>'

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
privs'" (or whatever the table name is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: "Incorrect information in fi

ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
whatever the table name is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: "Incorrect information in file: './path/admin

Re: InnoDb data file path

2002-10-09 Thread Arjen Lentz
Hi Scott, On Thu, 2002-10-10 at 03:28, Scott Pippin wrote: > I am trying to set up two data files in case the first one fills up. I > tried to use the following in my.cnf but it says there is an error. If > I take out the reference to the second data file everything works > > AIX 4.3.3 > MySQL

Re: InnoDb data file path

2002-10-09 Thread walt
Scott Pippin wrote: > I am trying to set up two data files in case the first one fills up. I > tried to use the following in my.cnf but it says there is an error. If > I take out the reference to the second data file everything works > > AIX 4.3.3 > MySQL 4.0.4 > > >innodb_data_file_path=libda

InnoDb data file path

2002-10-09 Thread Scott Pippin
I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4 innodb_data_file_path=libdata1:100M:autoextend:max:2000M;libdat

Re: File path

2002-08-12 Thread Iikka Meriläinen
Hello Alexander, Yes, it is possible. Start your mysqld(-max)(-nt) instances with --defaults-file=C:\windows\my.ini option and it should work. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland

File path

2002-08-12 Thread Alexander Burbello
Hi all, How can I change the file paht "c:\windows\my.ini". Is possible I have two files because I want to start two instances in same machine. I would like to change like that: - c:\windows\my.ini - c:\windows\my2.ini Regards Alexander sql, query __