What is the best way to insert data into a mySQL DB?

[Elledan]

The title says it all...

Please note that I'm talking about huge text files: multiple A4 pages.

[creole]

Elledan, while I am not a pro at all, I installed a PHP,Apache,mySQL bundle that gave me a tool called phpMyAdmin. It is basically a web interface to mySQL databases. It is very powerful and offers the ability to import text files. You might want to check it out.

here is the homepage for phpMyAdmin

[Koncise]

Hi,

I have a similar situation to Elledan, my website will mainly consist of a databse and I need to input large amounts of data into it....with as much ease as possible!!

Cerole, is the webserver an important factor when using PhPMyAdmin?

In my case I'm going to use a sambar server (at http://www.sambar.com/). Also importantly I plan to set up this server from my home PC.

Given the senario, is PhPMyAdmin still a good option?



Thanx,



K.

[creole]

I don't know enough about it to know if the server makes difference. I *think* that it simply interfaces with the mySQL database. Given that information, it would be logical to assume that it does not matter what server is used...

please correct me if I am wrong....

[Elledan]

Thanks for you reply, creole

Sorry for being so late, but it doesn't happen everyday that the power suplly blows and you're cut off from the internet for a week

I'll try the import function of PHPMyAdmin, let's hope it works

[Kevin Yank]

phpMyAdmin will work just fine on Sambar Server; however, if you'll be regularly inserting large text files into your database, your best bet would probably be to code a simple administration page in PHP that lets you upload the text file directly. The script would then read the data from the text file and insert it into the database.

[trigger8]

I'm trying to inport about 4000 text files into MySQL database. Do I need to insert them one by one, or there's an easier and faster way to accomplish that?

[Elledan]

I'm curious about that too, trigger8

So... Anyone?

[Zulu]

4000 text files. I assume the text files are in some directory structure and are named.

Do you wish to linked the files in the database or actually inserting the text file CONTENT into the database?.

Either way, a simple solution it to write some script/program that does this automatically (java, C++).

first is to get a listing of all the files. can be done 2 ways. Use the language API to list all the files with in the program and then pull out the contents and push them into the mysql database (use the mysql API).

Or the simpler but messy way. is to use the command/console to do a directory listing and save it to a file. then generate mysql QUERY from the filenames.

confusing? I don't have the time at the moment. But someone might understand and help. I can take a look at it, but no time to program, sorry.

[trigger8]

The content of the text files includes the title, and the article, in plain text. The file names, which are a series of numbers, will be used as the article's ID. For example, one of the file names is 63723.txt

I would appreciate if anyone could help.

Thanks.

[Zulu]

Send me a few examples and I'll see what I can do. I have a bit of time in a few days time.