MySQL Forums
Forum List  »  Microsoft SQL Server

Re: SQL Server to MySql
Posted by: Josh Chamas
Date: December 27, 2004 11:42PM

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:

which last I checked could take a text import/upload via a web form and
import it into a table.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
December 21, 2004 05:45AM
December 22, 2004 03:52AM
December 22, 2004 01:53PM
December 29, 2004 01:33PM
December 26, 2004 11:12PM
December 27, 2004 11:16PM
Re: SQL Server to MySql
December 27, 2004 11:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.