To answer your question

Tdgu — Thu, 30 Oct 2008 15:57:06 +0000

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.

I might be wrong, but this

JeevesBond — Tue, 28 Oct 2008 09:52:13 +0000

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:

If you are, as it seems, the same person, please pick one account and stick to it.
If you are two people trying to advertise the same product, please stop the fake conversations. But, both of you, do feel free to join in with the discussions.

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.

Hello everyone. Rusty, ETL

Tdgu — Mon, 27 Oct 2008 14:43:00 +0000

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?

I remember now that I first

decibel.places — Fri, 24 Oct 2008 23:40:12 +0000

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?

Yeah, phpMyAdmin can import

pr0gr4mm3r — Fri, 24 Oct 2008 20:49:14 +0000

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.

by "delimited" do you mean

decibel.places — Fri, 24 Oct 2008 19:20:45 +0000

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.

I haven't heard much about

pr0gr4mm3r — Fri, 24 Oct 2008 16:57:00 +0000

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?