SQL Import

[lemon-tree]

I am having quite some difficulty using the SQL import feature in PHPMyAdmin. I am trying to import a SQL table into a MySQL database that is 13MB in size with about 180,000 records. Currently, the browser status bar says it has been loading for 3 hours, however, the processes pane in PHPMyAdmin says that it stopped ages ago and the table is not updated. I have tried segmenting the query and I can get it to upload a small number at once, but it will struggle with anything above roughly 1MB. Splitting it up would be a good solution if I only had to import this table once, but unfortunately the data source updates once a month and I need it up to date.
I have also tried some 3rd party uploader scripts, but they seem to suffer the same problem, leading me to believe that the SQL server is just timing the query out. I also believe there used to be a SQL database import in CPanel, but that has disappeared.
The only other alternative is to upload the script that generates the table in the first place. I currently run it on my own MySQL server and it takes about 6 - 10 minutes of high workload file processing before I export it for uploading here; this high workload of course means that I would certainly be banned for excessive usage. Another consideration would be using an external MySQL server for that database, but I believe that external calls to SQL servers are not permitted here on X10.
Basically, can anyone suggest a solution to this, or is it just a consequence of being on a free server? It seems that whatever way I try seems to fail. Segmenting is not really a viable option.

Thanks,
Lemon

 

[Christopher]

Hello,

If you upload the file to your account and give me the file name and database you want it inserted on I can import it for you.