Hmmm ... several references online make it sound like that's all you should need to do (the alter table statement, that is).
My next step would be to try a 'CHECK TABLE data QUICK' to see if it reports anything unusual. If it does, issue a 'REPAIR TABLE data' command. If check table quick reports nothing unusual, I would next try a 'CHECK TABLE data MEDIUM' (or even EXTENDED), thought it could take quite a while. Then a repair table if it finds problems. Or I guess you could get right to the point and run 'REPAIR TABLE data' since it will not hurt anything if there are no problems! Barring that - I've not run into this problem, myself. You could possibly copy the data table into a new table, data2, discard the original, and rename the new to match the old. This would give you a table created from scratch with the proper size definition. Something like: create table data2 like data; show table status like "data2"; <-- check your max data length to ensure it's OK insert into data2 select * from data; <get coffee> <wait> <get more coffee> select count(*) from data2; <-- make sure your data moved OK drop table data; rename table data2 to data; If you're using anything complex like foreign key constraints this gets messy quickly though! Also, with 4.3 GB of data, the process of inserting the rows from data into data2 will take a while. Finally, you'll have to watch your disk space while this happens, as it's 4.3 GB of table plus indexes. Dan On 6/29/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
Yesterday: I ran the following command: ALTER TABLE data max_rows=11000000 Today: The client still reported table is full. I rebooted the client and stopped and started the mysql server. I still get the table is full error on the data table. I ran the command: \ echo "SHOW TABLE STATUS LIKE 'data';" | mysql -u user -p snortdb \ below is the output. Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment data MyISAM 9 Dynamic 8721565 497 4335220336 1099511627775 127599616 0 NULL 2006-06-28 20:54:55 2006-06-29 18:02:32 NULL latin1_swedish_ci NULL max_rows=11000000 \\ df shows /var the partition with the database has enoungh room: Filesystem 1K-blocks Used Avail Capacity Mounted on .... /dev/amrd0s1f 27792614 18449326 7119880 72% /var .... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
