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

2004-09-24 Thread Brian J.S. Miller
). 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_privs.frm') 4) isamchk (says: isamchk: error: 'admin_privs

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

2004-09-24 Thread kernel
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_privs.frm') 4) isamchk (says: isamchk: error

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

2004-09-24 Thread Brian J.S. Miller
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_privs.frm') 4) isamchk (says: isamchk

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

2004-09-24 Thread kernel
' (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 file: './path/admin_privs.frm') 4) isamchk

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 returns the error ___ is

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

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

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

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

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