Sorry for the long post, but I'm using with difficulty the 2nd edition
of Welling/Thomson's PHP and MySQL Web Development as a textbook for
self-teaching.
After being pleased to work my way thru to Chapter 14, not memorizing
the earlier material, but having some success basically understanding
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?
Assuming, no column heads are necessary--because they're already
I'm trying to learn to create database-driven websites on the Macintosh
using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina
great book published by the recently-defunct Glasshaus, Dreamweaver MX:
PHP Web Development.
I'm in the next-to-the-last chapter, trying to complete an
Well, MySQL is involved to the extent that the Web Development of the
title does involve MySQL database-driven applications.
So, is anyone familiar with this book. I'm in one of the last chapters
and I am hopelessly lost trying to find the proper places to input my
username, password, and db
Re: this latest version of MySQL. Has anyone installed a production
version of MySQL 4 on the Macintosh platform yet? Anything significant
to report? Advice not to do it yet?
Thank you.
Steve Tiano
-
Before posting, please
From what I understand, transactions are a kind of protection that
prevents certain commands from executing if certain other conditions
haven't been met. And this is particularly important for ecommerce,
among other things. Do I more or less have that right?
My main question, tho', is: Does
Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'?
I'm at a point in my intensive self-study via books, tutorials, and
exercises where one of the books I'm working with--trying to tie
together with my graphical HTML editor--Dreamweaver: PHP
Development--suggests
Oliver,
Thanks for responding. Foolish of me to be in such a rush that I wasn't
watching what I was copying and pasting. I actually did use the command
you suggest below. And that's what drew the error message.
So I'm back to the drawing board.
Take care, and thanks again--
Steve
Hy Steve,
Paul,
Thanks very much for responding.
I tried what you suggested, but got:
ERROR 1102: Incorrect database name '/Users/stephent/Sites/Temp.sql'
I don't get this. What wrong database name? The script is supposed to
create the database and a table in it. What an I too dense to see?
Thanks
Paul, Oliver--
I really, really appreciate you guys taking time from your respective
Sundays to try and enlighten me. But I'm still getting nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u root -p [the full pathname up
to]/Temp.sql
Guys, Guys--
I got it! I stopped being a dimwit long enough to realize that the
change to USE Temp; below was for INSIDE the script.
When I made that change and again went to a new shell and typed
(actually, I dragged the file from the window in which it sat in the
Finder into the Terminal
Stefan and Gerald--
Thanks for the input. Here's how I solved it ... I used a textfile that
had worked for me the very first time I did such an exercise weeks ago.
This particular textfile came on a CD with the book I was using. And by
copying and pasting, so that all the spacing and line
I'm just starting out, doing tutorials and exercises up the wazoo,
trying to learn MySQL and PHP.
I've created a table in a test database. When I do a DESCRIBE
[table_name], the columns come up just as they should. Populating them
with data's another story.
I've created a textfile in a text
Thanks to Gerald and Stefan for taking the time. Here's where I am ...
Perhaps because I'm still wet behind the ears, I brainlessly included
the column heads in the textfile. Of course, that's unnecessary.
I substituted \N for NULL and stuck \n at the end of each line--the
latter because I'm
Okay, I found User Comments at the end of the section of the user manual
online that contained the info I needed to get the option of loading a
textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile -p menagerie
where 'menagerie' is the
mysql
Thanks for responding, Paul. What's interesting is that pet.txt was
still not found when I used the path as you suggested. What would be
the reason for it being invisible?
Steve Tiano
So I issue the command
LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet;
and, for the first
I'm brand-new to MySQL/PHP and to this list, spending an interesting
holiday weekend devoted to trying to start learning the
MySQL/PHP/Apached axis.
There're three things that had me thinking of just giving it all up. But
after a night's sleep I can't deny still wanting to learn how to design
The manual I was able to download, I now notice, is for version
4.0.3-beta of MySQL. So that's the official tutorial I'm working. That
and Kevin Yank's Building a Database-Driven Web Site Using PHP and
MySQL--a '10-week course' that I also was able to download.
Problem has surfaced due to my
18 matches
Mail list logo