Hello.
>I went so far as to delete entire tables and recreate them. Can you create a new table (with name which you didn't use before) and check if the errors remain on the new table? Does REPAIR TABLE solve the problem? Also ensure that there are no another MySQL instances running? Or may be some other software has access to your files (antivirus)? Dan Tappin <[EMAIL PROTECTED]> wrote: > I had a previously stable 4.1.8-standard MYSQL install on OS X 10.3.x > Server using the binaries supplied by MySQL. > > Recently I have had multiple corruption issues with a database on > multiple tables. I keep getting "[ERROR] Got error 127 when reading > table" when trying to write to an effected table. I went so far as to > delete entire tables and recreate them. I could reproduce the error > from my default PHP and CLI attempts to write to the tables. > > The only thing that I recently changed on the server was the location > of the data directory. > > The Mac OS X install / upgrade places the data in > '/usr/local/mysql/data' where mysql is a symbolic link to the most > recent version installed in /usr/local/. > > I got tired of manually moving the data directory each time I upgraded > so I created a /etc/my.cnf file and specified the new data dir location > in /var/mysql/data/. I moved the old data for the last time checked > the permissions and ownership and restarted mysql. > > When I created the new my.cnf file I used the my-medium.cnf default > example as detailed below: > > [client] > port = 3306 > socket = /tmp/mysql.sock > > [mysqld] > port = 3306 > socket = /tmp/mysql.sock > datadir = /var/mysql/data/ > #skip-locking > key_buffer = 16M > max_allowed_packet = 1M > table_cache = 64 > sort_buffer_size = 512K > net_buffer_length = 8K > read_buffer_size = 256K > read_rnd_buffer_size = 512K > myisam_sort_buffer_size = 8M > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > > [isamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [myisamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > I have changed my my.cnf file to simply: > > [mysqld] > datadir = /var/mysql/data/ > > to see is one of these new parameters caused the problem > > Because I had no my.cnf I suspect that this is the problem. I tried > some Google and list searches with no meaningful results. > > Any tips / pointers / suggestions would be great. > > Dan T > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
