Quote:
5.12 will reconnect if connection is lost. But of course there are limits to how unstable connection can be for it to work
Nope. It will only reconnect when you execute query from the query window. SJA does not uses the reconnection mechanism.
Quote:
MySQL server has gone away
The error definitely seems to be due to the large number of columns but I cannot be 100% sure.
To debug I will suggest to perform the following steps:
1.) Import the schema only(no data). Thus it will only create the table structure i.e. an empty table. Is this step successful?
2.) Use 'Table Data' tab to fill in dummy values (reasonably close to the actual data) and see if you are able to insert. MySQL will throw “Server has gone away” too for this query itself. SQLyog will try to reconnect from the GUI, two times and then give up.
Just follow the above two steps for both partition and non-partition tables.
Basically, SQLyog as well as SJA, sends INSERT INTO queries to MySQL to enter data to the db. If it fails with SJA, it will defintely fail with SQLyog and the MySQL command line tool also and thus we will have a test case that can be submitted to MySQL as bugs (if its a bug with MySQL).
