Re: Repairing a table

2007-02-13 Thread Colin Charles
Ian Barnes wrote: Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do

Repairing a table

2007-02-02 Thread Ian Barnes
Hi, Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do anything on it, the

Repairing InnoDB table

2004-04-28 Thread Ville Mattila
Hello, I have a database using a few InnoDB tables. The database has not been in use for a while and now I noticed that all InnoDB tables in the database cannot be opened and used at all. Whatever I try to do, I got Can't open asiakkaat.InnoDB (errno: 1) error. I'd like to know, how could I

RE: Repairing InnoDB table

2004-04-28 Thread Victor Pendleton
Have the ib* files been removed or damaged? Depending on your configuration, these coulde exists in your mysql data directory. -Original Message- From: Ville Mattila To: [EMAIL PROTECTED] Sent: 4/28/04 5:28 AM Subject: Repairing InnoDB table Hello, I have a database using a few InnoDB

repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread mmokrejs
Description: 010827 16:24:44 Warning: Retrying repair of: './Mloti/blast_data' with keycache mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sinisa Milivojevic
Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Martin MOKREJ
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. kulan$ ls -la /home/mysql/Mbovis/cogs_data* -rw-rw1 pedant users54195408 Jul 4 03:52

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: If I should try also your binary distribution, please let me know. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sasha Pachev
cut Can you upload a copy of blast_data to ftp://support.mysql.com/pub/mysql/secret after verify first that what you plan to upload will crash a separate MySQL server on REPAIR? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
DST) From: Martin MOKREJ [EMAIL PROTECTED] To: Sinisa Milivojevic [EMAIL PROTECTED] Subject: Re: repairing MyISAM table kills mysqld with SIG11 On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: Please try out our binary distro. I guess that you would not like either that we spend our time

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
On Mon, 27 Aug 2001, Martin MOKREJ wrote: ftp://support.mysql.com/pub/mysql/secret Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's no secret directory. ;( http://pednew.gsf.de/cogs_data.tgz Hmm, try out http://kulan.gsf.de/cogs_data.tgz , but I'm sure the

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Sasha Pachev
mysql repair table cogs_data; ERROR 2013: Lost connection to MySQL server during query mysql quit 0x807b1b8 handle_segfault__Fi + 380 0x812af8a pthread_sighandler + 154 0x81517df free + 39 0x8114a6c my_no_flags_free + 16 0x8109304 mi_repair + 2236 0x80c4768

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web links I've sent to you via personal e-mail. Thanks. -- Martin

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Sasha Pachev
On Monday 27 August 2001 12:30, Martin MOKREJ? wrote: Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web

Repairing a table?

2001-01-29 Thread Kevin . Brown
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I searched the documentation on the site, but it doesn't seem to pertain to this version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can figure out what it might break. Does anyone have the steps

Re: Repairing a table?

2001-01-29 Thread Kevin . Brown
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I searched the documentation on the site, but it doesn't seem to pertain to this version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can figure out what it might break. Does anyone have the