Cant export 207MB table - Only 150MB gets saved

Hi,
When i try and export a wordpress table thats 207MB only 150MB gets saved. I only have Tables>Create checked and Data>Insert selected. Is there an export limitation or how do I split up the table?
Any ideas guys?
Thanks

exporting as sql btw

How exactly do you determine table size in bytes before and after? Do actual row counts* differ?

(*) SELECT COUNT(*) FROM foo

Hi,
Beforehand the table size is stated in the left hand side database tree in Heidi as 217 MiB and after export completes and the .sql is exported, the file is 147,000+ Kb in my folder on my PC.
Thanks

When I try and export entire db, that 1 table prevents tables after it exporting. Limit issue I guess. Somewhere

I think you are comparing pears and apples. The size of the binary data files will always be smaller than the SQL code you can use to generate them.

When I try and export entire db, that 1 table prevents tables after it exporting. Limit issue I guess. Somewhere

I beg your pardon? Do you get an actual error message of any kind or you're speculating? If you want to know whether your dump contains all the rows, load it into a temporary database and issue a SELECT COUNT(*) FROM whatever query. That's the only way.

Regardless when i export the db that has 10 tables only 6 tables get dumped. I upload the sql dump to a new db and 4 tables are missing.I guess the shared host may have an export size restrictions. Will ask them. Same issue with MySQL Workbench. Thx

I guess you get some error message in the SQL log when Heidi attempts to export the 7th table. You could check that and post the message here.