DOS commands & MySQL installation
Got Apache & PHP successfully installed - that was the easy part. MySQL is causing me some problems.
Now, I've got three different sets of installation instructions here. Two of them are telling me to find a file called my- example.cnf and move it to the root directory and rename it to my.cnf. One of these sets of instructions is telling me to edit this file as well. The biggest problem with this whole thing is that I can't find a my-example.cnf file.
Two of these sets of instructions are telling me to go into DOS to set up MySQL as a service in WinXP. I am completely clueless in DOS - I have no idea what to do. When the prompt comes up it's in the "My Documents & Settings" folder - how do I get to the mySQL bin folder?
mairving posted this at 03:51 — 8th March 2002.
They have: 2,256 posts
Joined: Feb 2001
Here are some DOS commands:
type cd directoryname to go to the directory.
type cd .. to go down a level.
type C: (or drivename) to go to the root of that drive.
So if you are in documents and settings,
type cd .., then cd mysqldirectory
dir will list all the files in that directory.
dir /p will do the same thing but will pause after every page.
to execute a file, as long as it has a valid .exe .com .bat extension, just type in the filename. So to execute filename.exe, type in filename
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
Busy posted this at 09:40 — 8th March 2002.
He has: 6,151 posts
Joined: May 2001
did you install PHP/MySQL/Apache as a set or seperate, if you did it as a set try it on Netscape.
my-sample can be displaying without the .cnf at the end, look in your mysql folder (this is the only folder mine is in, but I'm running win98se)
PHPMyAdmin is great for MySQL if you dont want to do all the long coding
Megan posted this at 14:29 — 8th March 2002.
She has: 11,421 posts
Joined: Jun 1999
Thanks, mairving! I did manage to get in there but it said that this service has already been installed...weird. Would you believe that there are basically no resources on DOS on the 'net? No beginner's guides or anything like that.
Busy - I installed them all separately. Thanks for the tips on my-example (it is example that I should be looking for, right? I think that's what my instructions said) Thanks for the tip on PHPMyAdmin.
Megan
Connect with us on Facebook!
mairving posted this at 14:51 — 8th March 2002.
They have: 2,256 posts
Joined: Feb 2001
The only thing bad about using PhpMyAdmin is that you don't really learn the SQL commands since it does those for you. It is like the difference between knowing HTML and using a WYSIWYG editor. It makes it harder to troubleshoot the code.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
Megan posted this at 15:19 — 8th March 2002.
She has: 11,421 posts
Joined: Jun 1999
Well, maybe I'll do a little bit of both, we'll see. I probably won't get to that for awhile yet anyway.
mmi posted this at 15:21 — 8th March 2002.
They have: 457 posts
Joined: Jan 2001
DOS tutorials - the real DOS
Busy posted this at 21:32 — 8th March 2002.
He has: 6,151 posts
Joined: May 2001
Mairving, your right about PHPMyAdmin, but when I started using MySQL (not very long ago) I didnt know where to type the commands (still dont lol), I figured at the DOS prompt but dont know DOS and none of the tuts tell you where, they just say: "copy this ..." or "type this ..." dont say how, where, to save as what if needed to be saved (example from text editor).
your very clued up
Mairving you want to sell a fraction of your brain
MMI is there a link you dont have something for
Megan - "my-example" file is spelt that way "my-example" in its properties it says .cnf but dosnt show it, doing a search for it only brings up the one, i searched for my-example. the file actually shows a shortcut icon but its not a shortcut
mairving posted this at 21:46 — 8th March 2002.
They have: 2,256 posts
Joined: Feb 2001
Well now, if I sold you a fraction of my brain, I wouldn't have any left.
The point is that it is a good idea to learn SQL if you plan to use it. Learn how to SELECT, JOIN, INSERT, UPDATE, etc and you will be a long way towards accomplishing your goal.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
mmi posted this at 23:01 — 8th March 2002.
They have: 457 posts
Joined: Jan 2001
yeah, a job
here's an intro to SQL (very sketchy summary)
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.