In this third installment of Russell’s MySQL series, he introduces some methods and tools for bulk importing of data into MySQL. This isn’t an overly difficult task, but processing large amounts of data can be intimidating for newcomers, and as a result it can be a barrier to getting started with MySQL.
Importing Data into MySQL
About The Author
Eugenia Loli
Ex-programmer, ex-editor in chief at OSNews.com, now a visual artist/filmmaker.
Follow me on Twitter @EugeniaLoli
<troll>
would you want to import data INTO MySQL … you would have better success exporting data FROM it and using a real database
</troll>
But in all honesty – MySQL really should not be used for any type of critical application but for simple web stuff, it works just fine.
Agree, although I might add that it can work fine for any simple application, not only web stuff, as long as you don’t need exotic or funky feature. Even the referential integrity is so-so…
I mean, really…can’t you find something else to whine about than complain about MySQL? I can tell you that MySQL 4.1 is solid enough to handle just about anything you would use an RDBMS for. I think people are just becoming jealous that it is so popular, and increasing in features every week. Ho hum.
A little off subject, but does any one know where I can grab the MySQL embedded lib for Mandrake 9.1?
I tryed a few of the MySQL-embedded.rpms from mysql.com but they seem to have linking problems during compile.
“I mean, really…can’t you find something else to whine about than complain about MySQL? I can tell you that MySQL 4.1 is solid enough to handle just about anything you would use an RDBMS for. I think people are just becoming jealous that it is so popular, and increasing in features every week. Ho hum.”
4.1 may be solid, but the *current* production version is missing key features that enterprise level businesses need *now*, not later.
>> But in all honesty – MySQL really should not be used for any type of critical application but for simple web stuff
>>
What do you mean by “critical application”? Email is critical, because if you are an ISP and your mail or radius systems goes down by 11 am monday morning, you will hear every cursing word on earth! We use a bunch of mysql servers to support thousands of users on dialup/dsl/email authentication. It works great. And one of those mysql servers has been continously up, without interruption, for the past two years!
>> 4.1 may be solid, but the *current* production version is missing key features that enterprise level businesses need *now*
>>
Sure, its missing a whole lot of things, but hey, how many enterprise-level businesses do you deal with? MOST of the businesses are nowhere near that level, and for these businesses, mysql works just great for most things.
And remember.. the best is yet to come.
“Sure, its missing a whole lot of things, but hey, how many enterprise-level businesses do you deal with?”
In my case, quite a lot – I have been employed by enterprise level businesses for the last 15 years and now spend most of my time working on mission critical e-commerce systems.
Everything we currently build runs against Oracle databases.
I mean, really…can’t you find something else to whine about than complain about MySQL? I can tell you that MySQL 4.1 is solid enough to handle just about anything you would use an RDBMS for. I think people are just becoming jealous that it is so popular, and increasing in features every week. Ho hum.
hahah, read
mysql->were addnig new stuff thats not even tested
compared to
postgress + firebird -> we’ve had this for YEARS..
Sorry but mysql isn’t a RDBMS. . . is a DBMS.
😮
Sorry but mysql isn’t a RDBMS. . . is a DBMS.
It has foreign keys constraints – that’s enough to qualify it as Relational. So it’s a RDBMS. Not a full-featured one, but a RDBMS anyway.