Failed to save modifications to server (mysql)

[Anonymous]

Hello,

Can anyone help me with this ?

I am fetching data from mysql with the help of vpn and ssh tunnel(with help of PuTTY). I am able to have access to the database and can preview the tables. When I try to load it, then this throw this error to me. The required table have more than 4 million records.

Thanks
Shubs 

[v-chuncz-msft · Accepted solution]

@Anonymous,

Yoiu may try to specify Timeout parameter in Advanced Editor.

https://msdn.microsoft.com/en-us/library/mt742860.aspx

[Anonymous · Accepted solution]

You can try to increase the timeout value and see if you can load the data successfully. By default, the timeout value is 10 minutes.

[Anonymous]

Hi @v-chuncz-msft and @Anonymous,

Thanks for your response. I finally resolved this error my adding durration in my query with your help.

Thanks

Shubs

[v-chuncz-msft · Accepted solution]

@Anonymous,

Yoiu may try to specify Timeout parameter in Advanced Editor.

https://msdn.microsoft.com/en-us/library/mt742860.aspx