Search found 20 matches

by BobH - TAN
Sat Jan 13, 2007 7:40 pm
Forum: Installation and Configuration
Topic: Having Problem Intalling MySQL and Simple Machines (SMF)
Replies: 0
Views: 457

Having Problem Intalling MySQL and Simple Machines (SMF)

If this is an inappropriate post or if I've posted in the wrong place, my humblest apologies. Please explain my error to me and I'll desist. The Problem: Although I can run phpinfo.php in Firefox at /localhost/ and see configuration options for Apache and PHP, no options for MySQL display. Also, I c...
by BobH - TAN
Sun Jun 04, 2006 8:51 pm
Forum: PHP - Code
Topic: Using PHP with a MySQL Database
Replies: 1
Views: 287

Using PHP with a MySQL Database

Howdy All! Been awhile, but I'm still just as ignorant as I was the last time you saw me. I need help using a MySQL database I've created. The database contains the names of all my high school classmates along with other information. Here are some things that I'd like to do: -- Whenever anyone wants...
by BobH - TAN
Sun May 07, 2006 3:02 pm
Forum: Databases
Topic: Need Help with LOAD DATA LOCAL INFILE in MySQL
Replies: 8
Views: 1773

LOAD DATA LOCAL

Hi Scottayy! Yes, I realize I can upload the table structure dump but there is no data in it. The table exists as the dump demonstrates. What I need to do is to populate its fields from the plain text file that contains my list of ~500 names. I don't know how to upload a *.txt file using PAM. Is tha...
by BobH - TAN
Sun May 07, 2006 2:46 pm
Forum: Databases
Topic: Need Help with LOAD DATA LOCAL INFILE in MySQL
Replies: 8
Views: 1773

LOAD DATA LOCAL

Hi timvw! Thanks for the response. I understand what you are saying; however, GoDaddy gives me no way to FTP (or transfer otherwise) the *.txt file to the host. I thought the whole purpose of the 'LOCAL' clause in the LOAD DATA statement was to allow the server side app to issue a read on the local ...
by BobH - TAN
Sun May 07, 2006 2:08 pm
Forum: Databases
Topic: Need Help with LOAD DATA LOCAL INFILE in MySQL
Replies: 8
Views: 1773

LOAD DATA LOCAL

Hi feyd! No, I don't understand your statement. In this case I truly don't know if I'm running anything on my local (client) machine other than the browser. From the way I invoke PAM via the browser, I assume that PAM is executing on the host server side. From reading the MySQL documentation, I unde...
by BobH - TAN
Sun May 07, 2006 12:27 am
Forum: Databases
Topic: Need Help with LOAD DATA LOCAL INFILE in MySQL
Replies: 8
Views: 1773

Client Side Function in LOAD DATA

Reading the MySQL documentation, it clearly states that inclusion of the term LOCAL after LOAD DATA and before INFILE sets up execution of the update file reads on the client side. The data are then passed over the connection (in this case the Internet) and the table loading is done on the server si...
by BobH - TAN
Sat May 06, 2006 5:24 pm
Forum: Databases
Topic: Need Help with LOAD DATA LOCAL INFILE in MySQL
Replies: 8
Views: 1773

Need Help with LOAD DATA LOCAL INFILE in MySQL

I'm trying to load a new, empty table from a tab separated fields file created in MSWord and saved as plain text with carriage return and line feed (CR/LF) after each line of data. Where there is no data in a field '\N' is placed to indicate a null value and is properly followed by either a tab char...
by BobH - TAN
Wed Mar 29, 2006 8:49 pm
Forum: Databases
Topic: phpMyAdmin and MySQL
Replies: 19
Views: 2663

Everah - Thank You! Those Were the MAGIC Words

Got right in and went straight to the place to name a database and define the number of fields.

Thank you VERY MUCH!!
by BobH - TAN
Wed Mar 29, 2006 12:18 pm
Forum: Databases
Topic: A Dumb Noob Question - Will MySQL Store jpegs?
Replies: 3
Views: 672

Read Enough of the "jpg" Search Replies to Underst

. . . my approach was all wet. Thanks, Feyd!

Guess I'll just upload 500+ thumbnails to my hosted server.

Thanks again!
by BobH - TAN
Wed Mar 29, 2006 12:00 pm
Forum: Databases
Topic: A Dumb Noob Question - Will MySQL Store jpegs?
Replies: 3
Views: 672

Thanks, Feyd!

I'll do the search. Might have to come back and ask you more about the storage and retrieval of the jpg's tho.
by BobH - TAN
Wed Mar 29, 2006 11:52 am
Forum: Databases
Topic: A Dumb Noob Question - Will MySQL Store jpegs?
Replies: 3
Views: 672

A Dumb Noob Question - Will MySQL Store jpegs?

Realizing that I'm a noob (despite advanced years and despite years of mainframe experience), I realize that there is probably an answer to this somewhere. So far, I haven't phrased the question correctly for Google to point me to an answer. The closest I've come is to a cryptic statement that the i...
by BobH - TAN
Wed Mar 29, 2006 11:45 am
Forum: Databases
Topic: phpMyAdmin and MySQL
Replies: 19
Views: 2663

Thanks, Again, Guys!

Yes, I want to get up and running with a database quickly; but I also want to learn how to handle PHP and MySQL. I was hoping that I could do the former with phpMyAdmin on my hosted server and the latter, over time, on a server running locally. (I downloaded and installed Apache -- at least I think ...
by BobH - TAN
Tue Mar 28, 2006 2:06 pm
Forum: Databases
Topic: phpMyAdmin and MySQL
Replies: 19
Views: 2663

Not Sure What You're Asking, jrd

First there's this in the "documentation.html" file: Setup script usage Since 2.8.0 phpMyAdmin comes with a setup script that can help you with creating configuration. This script is located in scripts folder: scripts/setup.php. Its usage is quite simple. You follow the dialogs and this sc...
by BobH - TAN
Tue Mar 28, 2006 10:41 am
Forum: Databases
Topic: phpMyAdmin and MySQL
Replies: 19
Views: 2663

Thank You, Both!

Really appreciate the advice. My intended use of phpMyAdmin was to get something functional on my site faster. I agree with agtlewis that there is nothing like mastery of a tool. feyd, I found and read the documentation.txt that came with phpMyAdmin. It mentioned that there would be a dialog when ru...
by BobH - TAN
Mon Mar 27, 2006 9:47 pm
Forum: Databases
Topic: phpMyAdmin and MySQL
Replies: 19
Views: 2663

phpMyAdmin and MySQL

You guys have been so helpful, I'm probably gonna wear out my welcome fast! Anyway -- I read a good tutorial on MySQL basics and want to get started. I have an account on GoDaddy which provides me with MySQL databases. I've done a couple of PHP tutorials (and am not above appropriating code out of t...