Closed

Send txt files to Mysql database

This project received 33 bids from talented freelancers with an average bid price of $126 USD.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Total Bids
33
Project Description

I need software that will send txt files into mysql database.

Explain:

Picture [url removed, login to view] :

- IP ADDRESS: here i must write mysql server ip Address

- PORT : here i must write mysql server port

- DB : here i must write database name

- USERNAME : mysql username

- PASSWORD : mysql password

- FOLDER : i must select from which directory will program catch all this .txt files.

----------------------------------------------------------------------------------------------------------------------------------------------

IMPORTANT!! Software must send txt files to mysql base when file change. File must be bigger than 0kb.

if file name is [url removed, login to view] this goes to table -> live_b,

if file is [url removed, login to view] it goes to table ->type_b ,

if file is [url removed, login to view] it goes to table ->ranking_b ,

if file is [url removed, login to view] it goes to table ->startlist_b ,

if file is [url removed, login to view] it goes to table ->obavijest_b ,

if file is [url removed, login to view] it goes to table ->naslov_b

Why to _b? - > because, this page will be refreshed every ~ 1 sec, and user can get blank page.

Sending data to mysql database - Example table LIVE

1) if file is [url removed, login to view] TRUNCATE live_b table

2) INSERT INTO live_b

3) RENAME TABLE live TO tmp_live, live_b TO live, tmp_live TO live_b

Pictures of databases, txt files, and program window are attached to project.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online