I'm trying to import a feed into a database that is 2.5GB and I've come across some sort of barrier. Apparently, the default php setup is 32bit and can not read such a large file and I need to recompile it to 64bit. Anyone know how to do this?
I believe, though don't quote me on it, the 2gb limit is an Apache limit not a php or mysql limit. So you may get more help posting in the apache section? http://forums.digitalpoint.com/forumdisplay.php?f=49
You may have to chunk up that database.... and do it in pieces. As for doing it in one big file... its out of my range of expertise. (ive never delt with something that big) If you look around the mySQL dev sites, you`ll find alot of people with enterprise level experience, they hit these problems all the time. Pick one of their brains.