Hi, I am a beginner in VB.net.
I have some problems here, that is how to transfer data between 2 different mySQL servers using VB.net? Myself have 2 solutions this problem but when i implement it, i face some difficulty.
1st solution is insert the data line by line means i select all the data 1st and put in 1 dataset, then i insert it line by line into the database. The problem for this solution is if my tables content too huge amount of data exp:400000++ lines, then the connection will lost(a mesage stated unable to detect server something like that) and i dunno why this thing happen?? (1st method transfer is so slow) How to set the connection so that it won lost?
2nd solution is outfile my data to a .csv file in a folder and then copy the folder to another mySQL server(share folder) later import it to the database. The problem i face here is sometime i able to copy the folder sometime i unable. If able, the time i would like to delete this file it will prompt a msg access denied. I really also dunno why? maybe due to share folder setting. If so, can tell me how should i configure it? ( this method is a bit faster than 1st solution)
Hope I can meet some expert here to help me solve my problems.If u do have any better solution or faster method to transfer data, please share with me.Thank you very much.