Dinangkur Kundu wrote:
> ...
> will help to generate reports from online mysql.
> So, he will be able to see reports everyday. Now
> site PC will go online after 10 pm and update new
> data to online mysql sever. How can I do that.
>
> If I dump all entered data for everyday in ascii
> file in a csv format and then send the csv to web
> server through ftp, after transfer the file. From
> website owner will click a button which will
> contain a function to import data from that csv
> file to mysql server.
>
Getting the data to the server running mysql might be the hardest part.
Note that file transfers over ftp are not secure and are handled as clear text.
It might be better to figure out how to do the file transfer over SSH or
HTTP file upload post over SSL or HTTPS. SSH & HTTPS file uploads can be automated.
Once its on the server, it should be fairly easy to hook up a program
that takes a user form post and calls mysqlimport to import the CSV file
into MySQL. A PHP script should be able to handle that. As another
approach, you might look at PHPMyAdmin at:
http://www.phpmyadmin.net/home_page/index.php
which last I checked could take a text import/upload via a web form and
import it into a table.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting