I have a xml file 80 MB i want to use it as database because of it's big i think that it will be hard to use it as database . is there another way to tell me instead of converting that xml file to mysql
A database is a far more efficient way to handle information information than a text file. Even several Gigs of data would be far better in a database than 80Mb in a text file. Depending on how complex the XML is you could parse it out into a csv file and import it into a database, or write a script to directly import it when you parse it out. You may want to check out navicat: http://www.navicat.com/. It can handle importing a ton of file types. I think it may be able to handle some xml.