automate transfer to a mysql database

They have: 3 posts

Joined: Aug 2008

Hi all

I receive regularly delimited files and I want to transfer them into a MySQL database. Ideally speaking, I would like the transfer to execute itself on a regular basis.

I heard that etl tools were able to do such a thing, is that right ?

Michael James Swan's picture

He has: 400 posts

Joined: May 2008

I believe that the PMA should have some tools that could be used which are built in to your MySQL server.

This is not always the case so you may need to look around.

pr0gr4mm3r's picture

He has: 1,502 posts

Joined: Sep 2006

A simple PHP script would take care of that. If you pull these CSV files from a specific location every time, PHP + a cron job would automate it nicely. Do you have any programming experience?

They have: 5 posts

Joined: Aug 2008

That's what I was going to ask...

If you have any some programming experience you will be able to take care of that with a simple script.

On the contrary , if you are a business user or if you are planning to perform other operations that data integration encompasses, you may want to use an ETL tool.

Some are user-friendly and open source.

You can have a look at Talend Open Studio for example, it is very easy to use even for non-technical users.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.