Transfer delimited files to Mysql database
Hi everybody.
I have several delimited files and want to transfer their content to a MySQL database. Before asking on this forum, I've been browsing the net and heard about open source ETL tools easy to use for non technical users. Can these products really be used by people who dont have much technical background like me and which one do you think is the most user-friendly ?
Thanks a lot for your feedback.
pr0gr4mm3r posted this at 16:57 — 24th October 2008.
He has: 1,502 posts
Joined: Sep 2006
I haven't heard much about them, I would write a script and import it that way.
If the tools are free/open source, why not just give one a try?
decibel.places posted this at 19:20 — 24th October 2008.
He has: 1,494 posts
Joined: Jun 2008
by "delimited" do you mean csv comma-delimited?
the phpMyAdmin tool included with most MySQL installations enables you to import from csv, I believe with a choice of delimiter(, or ; etc.)
I recently imported data from an Access database to MySQL using csv.
pr0gr4mm3r posted this at 20:49 — 24th October 2008.
He has: 1,502 posts
Joined: Sep 2006
Yeah, phpMyAdmin can import CSV files, but I'm pretty sure that the columns have to be in the right order. I guess if you create a table to fit the order of the CSV files, there shouldn't be a problem.
decibel.places posted this at 23:40 — 24th October 2008.
He has: 1,494 posts
Joined: Jun 2008
I remember now that I first created the tables and columns (setting each column's type etc.)
Maybe that is beyond the skill/experience of the op (Rusty)
Hopefully the open source ETL app can automate some of this...
What about NaviCat? I use it to perform queries, but haven't tried importing with it. I guess it is limited to SQL queries, right?
Tdgu posted this at 14:43 — 27th October 2008.
They have: 5 posts
Joined: Aug 2008
Hello everyone. Rusty, ETL tools are able to perform the transfer you're describing.
Working for Talend, we have an ETL tool you can use.
Since you describe yourself as a non-technical user, I won't waste your time with technical considerations. {{ product promotion removed by moderator (JeevesBond) }}
Now back to your question, do you only have CSV files or also other files?
JeevesBond posted this at 09:52 — 28th October 2008.
He has: 3,956 posts
Joined: Jun 2002
I might be wrong, but this whole thread is looking like one big advert. Tdgu, you and rusty have had several other near-identical exchanges on related subjects.
Your options:
We don't mind a little self-promotion occasionally, as long as it is on-topic. There is even a forum for that purpose. But we do not appreciate anyone trying to deceive our members with fake conversations.
a Padded Cell our articles site!
Tdgu posted this at 15:57 — 30th October 2008.
They have: 5 posts
Joined: Aug 2008
To answer your question JeevesBond, I am trying to promote an open source, free to download, solution I believe in. I had seen all of Rusty's messages and answered even though I do not know him. I was just trying to help him out of simple problems a lot of us have known at the beginning of our database development life. Its true though Rusty has redundant posts (probably a student?)...
I do not feel I'm doing abusive ads but simply proposing a free tool for people that seem to need it. I understand you can be wary about this. Now, am I not able to come back on the forum or are my next posts welcomed?
Thanks a lot.
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.