hello, i have here a text file whose data contains this kind of format, i hope someone could help me to import this kind of data into a mysql database, it is like a call format which contains the time of call, the trunk,the duration and other stuff. I need to seperate all those data and insert it in the database, the portion in the file which contains this kind of format (eac99e80-ec1f-11d9-9887-00c07b9aa0c4) is a unique one. and every call in this text file have 4 lines meaning 4 similar charracter like the one in parenthesis. hope someone could give me an idea, below is a single call format of the said test file.
and also the text file here has a size of 65000++ kb... hope someone could really help me... i have a code here that only splits the different portion of the line
PHP will stuggle with something like 65MB of data to load.
The only way I can see to do it with PHP is to read the file in chunks or break the file apart into smaller ones (other than increasing the 8MB limit in php.ini) but either are gonna be a pain.
timvw recently mentioned this mysql feature however which sounds like ti will do what you need
thanks so much d11wtq, ill try to use what timvw had mentioned, actually the other day i was looking at his site, thought i might get an idea on how to do that kind of text file, hehehe.. anyways ill try to post any solution i can get...
hope that someone is still there to hand an idea too....