Note: if you find a (free) program that already do this, as I'm sure it already exists, you can simply use it.
_____
I have a big table of data in a text file which columns are delimited by the character "|" and I update this big text file every day on my web server.
I need two things:
- a program, that I can execute some way on my shared host to be faster (ask me specifically if you have doubts on what technologies my shared host supports), that fastly moves data from it to an MySQL database on the same web server, without blocking the entire database (I mean in particular the possibility to do searches through it) during the process;
- a simple html page with a query form for doing searches through specified columns (1 or more) of this MySQL database, with support for boolean operators.
All this must be completed on my web server. I will give you the necessary username/password and I will create the MySQL database accordingly to your istructions.
Escrow offered.
Thanks.
Hi, i can do this job for you. I write script in Perl (most of *nix hostings support Perl) which parse your text file and insert values in MySQL. Second script will search MySQL database via web interface.
I have 7+ years experience in Perl and 4+ years experience in MySQL.
See PM for details.
Dear Sir,
I have experience in php and I can easily create such script that accept '|' delimited file and transfer it to mysql db. I can do it confidentally. Give me a chance. Thanks