Hello again! I'm currently inserting all my records into the table and suddenly after 1909152 records I get the error on an INSERT query :
The table <table_name> is full each record is 36 bytes * 1909152 records is 68729472bytes = 68.7mb I'm using innodb tables and innodb_data_file_path is set to innodb_data_file_path = ibdata1:200M; So I'm really not even half away from the total size. >From what I can read on http://www.mysql.com/doc/F/u/Full_table.html this should only happen when I SELECT data and not when I INSERT data? Does anyone know whats going on here? Another question is if I can just increase tha value of innodb_data_file_path = ibdata1 variable without losing my data? Thanks again!! Elm --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php