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]
