Is it possible 4 a program 2 take entries from a SQL database and insert into *.txt?

I have acquired a massive sql database of over 277,000+ articles. I'm sure you may have seen this database floating around in the "Buy,Sell,Trade:Content" forum. I need a program that will take each individual entry and save them into seperate text files.

This is my first encounter with databases so I have no idea where to start. The file is so large that it takes 10 minutes to open in UltraEdit, and trying to edit it freezes my computer for another 5 minutes!

Can anyone point me in the right direction?

 

Programs are limitless in their abilities. You just have to have enough time and the right plan.

I would suggest you look into VB.NET if you actually want to learn how to do it yourself. Otherwise, you'll need a coder.

 

I know a little VB.NET. I took a class two semesters ago. I still got the textbook. Maybe I should kill the spiders living in it, and give it a look thru.

 

try mysql code factory. Its a program u can use to convert mysql to txt and other formats.

 

If it is in MYSQL Insert statement format, you can use

BigDump - The Staggered MySQL Dump Importer

from ozerov.de to import it into MySQL. Once it is entered into Database,
you can view any individual Record or a simple program can be written
to create a separate file for each record.

Hope it helps.

Kuldeep

 

I can write a php script for that, if you need it..