The index file will rebuild by using the above command.
On Thu, May 19, 2011 at 11:16 AM, Ramesh wrote:
> Is that index and all will be fine in that table, or have to create again?
>
> On 19 May 2011 11:11, Ramesh wrote:
>
>>
>> Lost all the records once i done the repair table with use_frm.
>>
Is that index and all will be fine in that table, or have to create again?
On 19 May 2011 11:11, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_frm ;
>>
>>
>> On Thu, Ma
Can you paste the table files in the datadir and the execution part of the
below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_
Lost all the records once i done the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna wrote:
> Run this - repair table SystemEvents use_frm ;
>
>
> On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
>
>> mysql> repair table SystemEvents.frm;
>>
>> +--++-
Run this - repair table SystemEvents use_frm ;
On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
> mysql> repair table SystemEvents.frm;
>
> +--++--++
> | Table| Op | Msg_type |
> Msg_text
mysql> repair table SystemEvents.frm;
+--++--++
| Table| Op | Msg_type |
Msg_text |
+--++--++
| SysEvents.frm
use repair table table_name use_frm ; and try it out.
It needs to be run inside mysql.
On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote:
> Hi,
>
> I am trying to repair the table and i got this error
>
> I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI
>
> [root@uidsyslo
Hi,
I am trying to repair the table and i got this error
I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI
[root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql
/var/lib/mysql/tablog/TabEvents.MYI
check record delete-chain
- recovering (with sort) MyISAM-tabl
nes.
Regards,
Gavin Towey
-Original Message-
From: tly...@sitehelp.org [mailto:tly...@sitehelp.org] On Behalf Of Todd Lyons
Sent: Thursday, September 10, 2009 3:44 PM
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: DB/table problem
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote:
mysql@lists.mysql.com
Subject: Re: DB/table problem
OK, All I have then is a bunch of .frm files.
Can I recover the data from the FRM files if I install mysql 5.0 without
INNODB?
Thanks,
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey
mailto:gto...@ffn.com>> wrote:
When using innodb, your data i
ell. 4. Restart mysql
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: Néstor [mailto:rot...@gmail.com]
> Sent: Thursday, September 10, 2009 11:28 AM
> To: mysql@lists.mysql.com
> Subject: DB/table problem
>
> I am running mysql 5.0 on a windows 20
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote:
> When using innodb, your data is stored in the data/ibdata* files. Copying
> the database directory is not a valid backup.
>
> In the future, I would suggest using mysqldump. However if you want to make
> a file-system copy backup with innod
the data directory 3. Store a copy of your my.ini with the
backup as well. 4. Restart mysql
Regards,
Gavin Towey
-Original Message-
From: Néstor [mailto:rot...@gmail.com]
Sent: Thursday, September 10, 2009 11:28 AM
To: mysql@lists.mysql.com
Subject: DB/table problem
I am running mysql
I am running mysql 5.0 on a windows 2003 host with php and apache
I am trying to restore a database from 08/28/2009. The backup is done by
windows and all I do is copy the "data/scroller612" folder to the DATA
folder in the MYSQL directory.
when I restore/copy it I get the following errors my .e
fraid that when the table gets
to that size it is going to crapped out again. Is there anything that I may
not be taking into consideration.
Thanks,
ZK
--- On Thu, 7/9/09, kabel wrote:
> From: kabel
> Subject: Re: Table problem
> To: mysql@lists.mysql.com
> Date: Thursday, Ju
et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: li...@voidship.net
> To: mysql@lists.mysql.com
> Subject: Re: T
On Thursday 09 July 2009 01:56:37 pm Zakai Kinan wrote:
> I have been getting this error on a database: Incorrect key file for
> table '/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table
> is causing this error?
>
>
> TIA,
>
> ZK
You could be running out of space on your temp pa
I have been getting this error on a database: Incorrect key file for table
'/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table is causing
this error?
TIA,
ZK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
LOL - Now I feel silly.
Thanks that worked.
R
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, December 15, 2006 5:37 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: RE: Strange table problem
At 03:44 AM 12/15/2006, Ruan wrote:
>Hi,
>
>
At 03:44 AM 12/15/2006, Ruan wrote:
Hi,
The dump revealed this:
+
| View | Create View
| test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY
DEFINER VIEW `test` AS select `beta_users`.`user_id` AS `user_id`,`b
PROTECTED]
Sent: Friday, December 15, 2006 10:43 AM
To: Ruan
Cc: mysql@lists.mysql.com
Subject: Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
>Hi everyb
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop it.
I tried with phpmyadmin and with mysql from command-line.
If I try to view it I receive this error:
View 'product_beta.test' references inva
Eric Anderson wrote:
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prb
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prblem for some reason, I
Hi,
When I try to repair a database that has been marked as crashed, I get the
following error:
| db.table | repair | info | Key 1 - Found wrong stored record at 885548
|
| db.table | repair | error| Not enough memory for blob at 885648 (need
842150190) |
| db.table | repair | inf
Try running a flush tables in mysql to make sure that mysqld knows about
all the tables on disk.
xtcsuk wrote:
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it works just fine.
Running a Show Table command lists table1 as an existing table and
trying to create table1 complai
There are lots of ways to do this, from simple (lookup table and bridge
table) to more complex (eg dynamic trees of nodes and edges). You'll
likely have to experiment to find the solution that performs best in
your context. Often simple is best. Here's a simple representation I
used for a movie
Dear friend,
I am classifying some items. The items will be stored in a large MySQL
database (probably InnoDB engine). At storage time, we would like to append
a series of descriptive categories to the item, in order to facilitate
"friendly", very flexible searches later.
For instance item A
I'm remotely administering a fedora 2 snort box via ssh.
running snort with
snort -c /etc.snort/snort.conf is fine - that is everything is logged
to tables and shows in acid.
But if i leave it running for over about a minute it buggers up. I
lose my ssh and acid/apache service. I then have to get
> Leonardo,
>
> Earlier you said that a statement without a parameter ('?') works, but
> one with a parameter doesn't.
>
> In both cases, are you still using a PreparedStatement?
>
> -Mark
>
yes, it is always a preparedstatement.
If you need more details (or you want me to try something
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leonardo Francalanci wrote:
>> What happens if you use a nightly snapshot of Connector/J from
>> http://downloads.mysql.com/snapshots.php?
>
> I tried, but I still have the same problem:
>
> java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsExcept
Richard F. Rebel wrote:
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
Yeah, I also have problems taking snapshots of my cat... use FEL to
pre-flash so he won't blink when you take the actual pictur
tel.ie> Fax to:
Subject: R: R: R: connectorJ & huge
ta
> Next time you come over, maybe you can help hold him or take the shot.
> He's such a pain to take pictures of, he walks right up to the camera.
Mmmh... my English is very bad... I can't understand...
is it a joke or just a mistake?
--
MySQL General Mailing List
For list archives: http://lis
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
On Tue, 2004-06-22 at 09:50, Leonardo Francalanci wrote:
> > It looks as if you are being over-complex anyway. Isn't what you want
> >
> > SELECT * FROM
> What happens if you use a nightly snapshot of Connector/J from
> http://downloads.mysql.com/snapshots.php?
I tried, but I still have the same problem:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepa
> It looks as if you are being over-complex anyway. Isn't what you want
>
> SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ;
>
> which picks a single random record.
No, I have to know which is the ID I pick before doing the select
(because I splitted my data, and when I access the splitted
"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote on 22/06/2004
14:26:54:
> > A non-streaming connection will place the resultset in memory. With
large
> > tables you can run out of memory and the application will stop.
>
>
> I get only 1 record per time (accessing by key), so I don't think
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leonardo Francalanci wrote:
> I have a large table (64,000,000 rows).
> Everything was fine when the table was 16,000,000 rows,
> now connectorJ crashes:
>
> java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
> at
>
com.mysql.jdb
rt a bug in a couple of days...
> -Messaggio originale-
> Da: Leonardo Francalanci [mailto:[EMAIL PROTECTED]
> Inviato: martedì 22 giugno 2004 15.09
> A: Mysql
> Oggetto: R: connectorJ & huge table problem
>
>
> I have also weird results:
> I access data
> A non-streaming connection will place the resultset in memory. With large
> tables you can run out of memory and the application will stop.
I get only 1 record per time (accessing by key), so I don't think
it could be an issue.
Thank you anyway!
--
MySQL General Mailing List
For list archi
was
non streaming.
-Original Message-
From: Leonardo Francalanci
To: 'Mysql '
Sent: 6/22/04 7:55 AM
Subject: R: connectorJ & huge table problem
> Are you using a streaming connection?
ehm... how do I know?
My conn string is
jdbc:mysql://192.168.0.253:3000/LETSPARTY1?
> Dude. I wouldn't post your server ip here. ouch.
Well, it's a LAN address!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2004 8:55 AM
To: 'Mysql '
Subject: R: connectorJ & huge table problem
> Are you using a streaming connection?
ehm... how do I know?
My conn string is
jdbc:mysql://192.168.0.253:3000/LETSPARTY1?autoReconnect=yes
where 192.168.0.253 is a machine on my LAN...
--
MySQL Ge
i [mailto:[EMAIL PROTECTED]
> Inviato: martedì 22 giugno 2004 14.43
> A: Mysql
> Oggetto: connectorJ & huge table problem
>
>
> I have a large table (64,000,000 rows).
> Everything was fine when the table was 16,000,000 rows,
> now connectorJ crashes:
>
> java.s
> Are you using a streaming connection?
ehm... how do I know?
My conn string is
jdbc:mysql://192.168.0.253:3000/LETSPARTY1?autoReconnect=yes
where 192.168.0.253 is a machine on my LAN...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Are you using a streaming connection?
-Original Message-
From: Leonardo Francalanci
To: Mysql
Sent: 6/22/04 7:43 AM
Subject: connectorJ & huge table problem
I have a large table (64,000,000 rows).
Everything was fine when the table was 16,000,000 rows,
now connectorJ cra
I have a large table (64,000,000 rows).
Everything was fine when the table was 16,000,000 rows,
now connectorJ crashes:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStateme
nt.java:908)
at
Hello *
reproducable Problem:
Content of UNION:
logs_20040608,logs_20040609,logs_20040611,logs_20040612,logs_20040613,logs_20040614,
logs_20040615
results: 0E0
DBD::mysql::db do failed: Can't open file: '#sql-13c1_12.MRG'. (errno: 144) at
/usr/local/sbin/new_MERGE_table.pl line 276.
Unable to
Hi,
I'm running mysql version 4.0.13 and trying to create a temporary table
from a php script. For some reason, even though I have the permission
set up correctly, I can't seem to create a temporary table from the
script. The permission say that create_tmp_table_priv=Y for the user in
my connectio
I am ausuming you are using the same user from both PHP and the mysql client.
But are you doing both locally? There may be two user records, one for
localhost and one for remote connections (or something to that effect).
Just a thought.
-Jackson
On Monday 11 August 2003 1:52, Miretsky, Anya
"Miretsky, Anya" <[EMAIL PROTECTED]> wrote:
>
> I'm running mysql version 4.0.13 and trying to create a temporary table
> from a php script. For some reason, even though I have the permission
> set up correctly, I can't seem to create a temporary table from the
> script. The permission say that cr
> > Further to this, I should point out everything works fine in mysql-front
> > or at the mysql console.
> >
> > The problem shows up when using mysql++, a BadQuery exception is thrown.
> >
> > query.reset();
> > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
> >
; " TYPE=HEAP
MAX_ROWS=1 " << subselect;
try
{
query.parse();
query.execute();
}
- Original Message -
From: "Phil Bitis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 12:41 PM
Subj
As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to v4.0.1
2003年 7月 7日 月曜日 18:02、Rafal Kedziorski さんは書きました:
> At 17:58 07.07.2003 +0900, Nils Valentin wrote:
> >2003å¹´ 7月 7æ—¥ 月曜日 17:43ã€Rafal Kedziorski
ã•ã‚“ã¯æ›¸ãã¾ã—ãŸ:
> > > hi,
> > >
> > > I'm porting an PostgreSQL script to MySQL. I get an error:
> > >
> > > Can't create table '.\m
At 17:58 07.07.2003 +0900, Nils Valentin wrote:
2003年 7月 7日 月曜日 17:43、Rafal Kedziorski さんは書きました:
> hi,
>
> I'm porting an PostgreSQL script to MySQL. I get an error:
>
> Can't create table '.\mmcms\mandant.frm' (errno: 150)
>
> for this tables:
>
> CREATE TABLE `firm` (
>`firm_id` SMALLINT
2003年 7月 7日 月曜日 17:43、Rafal Kedziorski さんは書きました:
> hi,
>
> I'm porting an PostgreSQL script to MySQL. I get an error:
>
> Can't create table '.\mmcms\mandant.frm' (errno: 150)
>
> for this tables:
>
> CREATE TABLE `firm` (
>`firm_id` SMALLINT NOT NULL AUTO_INCREMENT,
>`name`VARCHAR
hi,
I added two indexes in mandant table
CREATE TABLE `mandant` (
`mandant_id`SMALLINT NOT NULL AUTO_INCREMENT,
`firm_id` SMALLINT NOT NULL,
`parent_id` SMALLINT,
`name` VARCHAR (20) NOT NULL,
`creation_date` TIMESTAMP NOT NULL,
#
PRIMARY KE
hi,
I'm porting an PostgreSQL script to MySQL. I get an error:
Can't create table '.\mmcms\mandant.frm' (errno: 150)
for this tables:
CREATE TABLE `firm` (
`firm_id` SMALLINT NOT NULL AUTO_INCREMENT,
`name`VARCHAR (40) NOT NULL,
#
PRIMARY KEY (`firm_id`)
) TYPE=InnoDB;
CREATE
Hello everyone,
I am running MySQL version 3.23.52 on Mandrake 9.0 and access it from a web
application running on IIS on Win 4.0 Service pack 6a with MyODBC version
2.50.39.
The problem I am having is when I create a temporary table and then query
the temporary table I get a Table doesnt exist
HI!
I hope someone can help me with the following problem.
i have a table A type innoDB
THREAD 1 makes following query's:
SET AUTOCOMMIT=0;
SELECT * from table A where field1='value1' FOR UPDATE;
and now comes a new THREAD 2 while THREAD 1 is still holding the row
lock on Table A
THREAD 2 mak
Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Wednesday, June 19, 2002 12:37 AM
Subject: Re: Alter table problem
> > Ferdek,
> >
> > what character set you have specified in my.cnf? I tested your script
with
> > latin1 (the default) and 3.23.52, and it seemed to work witho
Ferdek,
what character set you have specified in my.cnf? I tested your script with
latin1 (the default) and 3.23.52, and it seemed to work without errors.
For example, for the table reklamacja you see below it created the 3 foreign
key constraints.
Can you provide a simple repeatable test case
Hello everybody !
I just give up. Can somebody tell me, what I do wrong ?
Here is script:
CREATE DATABASE servcontrol;
USE servcontrol;
CREATE TABLE czesc (
id_czesci CHAR(100) NOT NULL,
id_hurtowni TINYINT UNSIGNED NOT NULL,
id_nazwy INT UNSIGNED NOT NULL,
dokument SMALLINT UNSIGNED N
[EMAIL PROTECTED] writes:
> >Description:
> Found block with too small length at 1928; Skipped
>
> >How-To-Repeat:
There's no real point in sending bug reports that don't
say anything about what's wrong or how to reproduce the
error. That your table is corrupted could be because of
a power out
>Description:
myisamchk -foe /mail/torba/bucho
- recovering (with keycache) MyISAM-table '/mail/torba/bucho.MYI'
Data records: 66
Found block with too small length at 1928; Skipped
Found block that points outside data file at 1320584
Found block that points outside data file at 1590764
Found blo
>> the table becomes corrupted. Is this some limitation of inno DB or should I
>> separate the UPDATE process in two separate UPDATE statements?
>It's a known and confirmed bug that will be fixed in 3.23.42. There
>was an announcement just posted about this a few minutes ago.
Hi Jeremy,
thanks
On Sun, Aug 26, 2001 at 09:10:31PM +0200, Ralph Graulich wrote:
> Hi,
>
> recently I converted a table containing a large amount of text
> fields from myISAM to inno-DB and encountered a problem I can't help
> with. The table structure consists of:
>
> textref_id INT(12) UNSIGNED
>
Hi,
recently I converted a table containing a large amount of text fields from
myISAM to inno-DB and encountered a problem I can't help with. The table
structure consists of:
textref_id INT(12) UNSIGNED
textref_cat_id INT(12) UNSIGNED
textgroup_key CHAR(5) NOT NU
At 12:37 31/05/2001 +0200, Vili Germic wrote:
Hi!
The issue mentioned is relative to the Windows security privileges.
If the workstation connected or the local user doesn't has privileges
to delete files on the /mysql tree, that error message is launches.
Click over the MySQL folder icon with th
Just one thing I can think of..
Have you got GRANT privileges to drop DB?
Simon
-Original Message-
From: Vili Germic [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2001 11:37
To: [EMAIL PROTECTED]
Subject: DROP TABLE problem!
Hello everybody,
MySQL - 3.23.38 Win
MyODBC - 2.50.37
I&#
Hello everybody,
MySQL - 3.23.38 Win
MyODBC - 2.50.37
I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver.
2.50.37) to connect to db trought ODBC. Things works well, except for
dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC.
Trought SQL statement
Hi,
I have a problem with mysql users. I can`t connect to database with any
user when I use password. Eg, if from the command line I try to connect
like mysql -h myhost -u myuser -p and then on the password line write my
password, it gives permission denied...
If I try to go in just without
Hi All!
I just posted a note about having problems creating temporary tables.
However, I JUST realized (and empirically verified) that my problem of not
being able to create temporary tables is that I didn't use an ID with the
CREATE permission enabled. I am a bonehead.
Thanks again!
Cheers!
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> I'm trying to use merge table for logging - to have a possibility to
Peter> Rotate log files and to quickly delete old data - for this I'm goint
Peter> to setup a number of merge tables where each co
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> I'm trying to use merge table for logging - to have a possibility to
Peter> Rotate log files and to quickly delete old data - for this I'm goint
Peter> to setup a number of merge tables where each co
On Fri, Feb 16, 2001 at 05:58:27PM +0300, Peter Zaitsev wrote:
> Hello monty,
>
> I'm trying to use merge table for logging - to have a possibility to
> Rotate log files and to quickly delete old data - for this I'm goint
> to setup a number of merge tables where each contains data for one
Hello monty,
I'm trying to use merge table for logging - to have a possibility to
Rotate log files and to quickly delete old data - for this I'm goint
to setup a number of merge tables where each contains data for one
day, and the inserts are done to the last table using real table
name
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid
Hi.
You posted to the wrong list. This list is for developing of MySQL itself.
As for your problem, MySQL does not have a good solution at this point. Have
you tried using the BACKUP command? It will flush and lock the table and
copy only the data and .frm files. A RESTORE will rebuild the index
Hello there,
I was hoping you guys could help me with a little problem I'm having with
MySQL.
I'm trying to dump the contents of one field of a multi-field table to a
text file. The table is on the large side (about 3 million rows).
Whenever I run:
SELECT rowname FROM table INTO OUTFILE somef
Hi!
> "Goodman," == Goodman, Michael <[EMAIL PROTECTED]> writes:
Goodman,> I'm not sure exactly what happened, but mysql was freezing everytime I tried
Goodman,> to access a particular table...everytime I tried to select anything from it,
Goodman,> alter it, drop it, whateverjust nothin
I'm not sure exactly what happened, but mysql was freezing everytime I tried
to access a particular table...everytime I tried to select anything from it,
alter it, drop it, whateverjust nothing worked and mysql crashed. I
ended up having to temporarily remove the table files, kill mysql and
re
86 matches
Mail list logo
