ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
I used 300 for my AVG_ROW_LENGTH because I calculated my average to be about 260 bytes/row. YMMV
*WARNING* if you are doing this because the table is too big.. THIS WILL TAKE A LONG TIME.. COULD BE HOURS. during this time you will be able to query the table, but *NOT* update records.
Import spreadsheet (csv) data into mysql database (Russell)
Add comment or question...:
This file (the script that presented the data, not the data itself) , last modified Wednesday 03rd of December 2014 09:40:39 AM
your client: CCBot/2.0 (http://commoncrawl.org/faq/)
current time: Wednesday 28th of June 2017 03:04:13 AM