I've come to find out that my databse is a flat database, and I don't need a relational database like MySQL. Do you have any other suggestions for software other then MySQL, read into dynamic web pages by .php?
I recommend MySQL Front. It allows you to import data from many different databases. You may be able to go back to the original database and re-export it in native format instead of as a comma delimited text file. It also can import the data from a text file if you wanna go that way
Thank you all for your insights, but I seem to be way in over my head with starting to work with MySQL. When trying to help me find answers, please treat me as a 10 hour newbie. (I 've actually been trying for about 30 hours now)
danyprundus: What's an SSH?
pyoor: MySQL Front downloads as a .exe file, which is not much use on my Mac.
daveman: for now, I'm just trying to upload data, I can't get phpMyAdmin 2.5.6 to read my text file. I'm not even to the point of using the data, I just wanna get it in the .db.
I have a simple tab delimited text file, with only 3 words of data.
phpMyAdmin 2.5.6 has created a table for me, and there are only 3 text fields in it. It only has one row of data now.
here is my text file to upload:
Test Eastern Shore Associates Insurance SILVER
here is an export, the data that typed in manually:
# phpMyAdmin SQL Dump
# version 2.5.6
# Host: localhost
# Generation Time: May 25, 2004 at 01:52 AM
# Server version: 3.23.41
# PHP Version: 4.0.6
# Database : `test`
fyrestrtr: Thank you for some of the missing syntax.
I still get this error when I uses phpMyAdmin:
#1083 - Field separator argument is not what is expected.
I cannot find documentation on this error number.
"Test" "Insurance" "SILVER"
Also, Thank you for the .php script.
I cannot read it, and don't know where to put it to operate it.
Paste into phpMyAdmin? Where?
I haven't had a chance to learn much .php yet, although it is obvious that I need to.
I've done years of work with the SmithMicro product WebCatalog, so I thought that I knew database theory. But each reply you make raises more questions than answers, I am assuming that my experiences with other database coding software is useless.
I realize that I'm an absolute beginner at this. I do have several manuals open on my desk, and I am trying to pick this up, but the starting curve seems aweful steep to me.
danyprundus: Thank you for your offer, but uploading a file is step 1 of 1000 for me at this point. I don't see how it would help in the long run.
Thank you all again. I'm going back to attempt to upload a file for the 300th time. :-)
1. Save the code in a file with a .php extension
2. Change somefile.txt to the name of your file that contains the information.
3. Upload both files to a location on your webserver (make sure both are in the same directory).
4. Browse to the location of the .php file (if you called the file test.php, you should browse to http://www.yourserver.com/test.php)
5. Copy the output from the script (whatever is displayed on the page).
6. Login to phpmyadmin
7. Click on the table called vendor on the left hand column
8. In the right hand frame, click on the tab marked SQL
9. Paste the text from step 5 in the resulting box (delete anything there first)
10. Hit Go.
In order to understand recursion, one must first understand recursion.
If you feel like it, you can read my blog
Signal > Noise