ERROR 1114 (HY000): The table is full I am trying create a table using a cross join or Cartesian Product subquery that creates a table with a large number of rows, like at least 148 million rows.  I get this


  ERROR 1114 (HY000): The table is full.


I plan on filtering and querying the table later on, but how can I create this table?
Check, if you did not run out of disk-space (this is the first step, check the tmp file)

From the comments, You seem to have a too low maximum size for your innodb_data_file_path, You cannot host more than 512MB of data in all innodb tables combined.

I think you should switch to an innodb-per-table scheme using innodb_file_per_table.