Thanks, as it turns out the solution to the problem was a bit more mundane: we ran out of disk space on the partition the tables are on. :>)
--Walt On 10/11/05, walt <[EMAIL PROTECTED]> wrote: > > Walt Weaver wrote: > > >Hi, > > > >I have a job runnning that's modifying a column on a 15-million-row table > >and is throwing out the following error: > > > >Output: Replication Error 1114, slave: replicatenj07, error: Error 'The > >table '#sql-5303_3c' is full' on query. Default database > >'customer__upgrade'. Query: ALTER TABLE inc_performance MODIFY > COLUMN..... > > > >This indicates to me that the temp table is full. Problem is, I'm not > sure > >what config parm or whatever needs to be changed to allow the temp table > to > >grow sufficiently. > > > >Can someone push me in the right direction on what to change, or if I'm > >barking up the wrong tree, show me which tree to bark at? > > > >Thanks, > >--Walt Weaver > >Bozeman, Montana > > > > > > > Walt, > Run > mysql> show variables; > > There are several config options for temp stuff such as size & > directory. I don't know the syntax to change these off the top of my > head but it should point you to the correct "tree". > :-) > > walt > >
