Stephen Tiano wrote:
What I'd like to do is create a textfile and then import the whole thing
into a table. So, naturally, I've a few questions.
Do I need to include the column heads as a line in my textfile, or can I
simply go straight to the data?
No ... you can simply go straight to the data
MyWeeklyLeads.com wrote:
I have a flat file that I am trying to load to a MySQL database
(fixed-length fields).
When I try:
LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable
It is generating a ton of errors, but the end result is that it's populating
only the first field for all records and al
Hi,
I need to periodically load a dumpfile from another DB into
mysql. Now, since this is a cronjob, and for which I would
need to avoid interactivity, I DO NEED to run this as a
non-root user.
I have setup such a user, and have granted the user all on
the destination database. The user also has