1 reply to this topic

[Hash]

Hey all, I have a script that must import a massive amount of data into my mysqldb. I've been googling around for a good way to do this, buuut, all seem to tell me to alter my server's settings. Well, unfortunately, that's not an option here. Problem is, going the existing way, I hit a 500 internal service error every time my script runs on some of the larger operations. So, what I'm really looking for, is a way of "staging out" the biggest part of the operation, but haven't seen much detail on how to do this. Any help here?

[Alexander]

Your my.cfg has various options regarding to cache/performance values you can tweak to ensure transfer, you can look up the official guide on recommendations of those settings.

You did not state your purposes of importing large data, how and what are you importing, can you not do it serverside using mysqldump?