Re: 2 GB limit reached

[Dan Nelson]

In the last episode (Jan 08), Dennis said:
> We have a database that seems to have grown too large, and now any
> operation fails on it. How can we fix this?

If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB table with multiple 2gb tablespace files. 
Then "INSERT INTO newtable SELECT * FROM oldtable".

If you can't select from it, you might have to run myisamchk to repair
the table, or transfer the table to an OS that does not have the 2gb
limit and split the table there.

-- 
	Dan Nelson
	dnelson@stripped