PDA

View Full Version : n00b with a mySQL problem


CSDsan
2-5-04, 03:28 AM
Okey, it's late, and I've spent a good portion of the day trying to figure this out, and I've lost about half my hair, due to me ripping it out in frustration. Heres my problem:
I was trying to install a image upload script (this one (http://www.hotscripts.com/Detailed/30967.html) )and suddenly I cant view my website anymore (http://www.q-designs.net). Okey, so I figure I must have messed up some file somewhere in my main directory. So I deleat everything in .htdocs and make a quick test page that just says "test...". Anyways, that fails, and so i come to figure that theres something wrong with my mySQL stuff. I dont quite remember how I came to that conclusion, but yeah. I'm pretty sure it's that. Anyways, i downloaded the two dumps of my database the server had. Okey, i thought all I had to do from there was upload them to the mySQL database, and voila problem solved. I dunno if thats true or not, because I CANT FIGURE OUT HOW I'M SUPOSED TO FREAKING DO THAT.
Anyways, I tried downloading some programs that would let me recover my database with the dumps, and that would have worked (I think anyways lol) but, oh yes, you can't access your mySQL database from remote locations, it has to be accessed from a web-based aplication. Woo and yay. I also saw this (http://forum.powweb.com/showthread.php?s=&threadid=20022) and I dont know how to get that to work.
Also, I cant figure out how to deleat the mySQL database information. Hell I probably screwed it over even more by trying to deleat things, and failing miserably. I dont know ANYTHING about PHP and mySQL. Oh yes, and to top this off, I don't even know if its this mySQL and PHP crap thats causing a problem.

Righty, thanks A LOT , if you can help me, and please remember, im pretty much a total n00b at this. And Im sorry if I sound rather.. mean and mabe like a jackass, but I've spent a good portion of my time trying to figure this out. Im really really stressed right now.
Thanks again if you can help me out :) and I tried to give you all the info I could.

user9999
2-5-04, 04:11 AM
It is late, quick comment, permissions on /htdocs are messed to start off with,
try chmod 755 for starters

HalfaBee
2-5-04, 05:29 AM
It is a bit overwhelming when you first jump into the world of internet servers.
Make sure your htdocs is chmod to 755.
Do this with an FTP program like www.smartftp.com .
If you right click on htdocs you will see the permissions/chmod at the bottom.

Most other files should be 644.

Make sure there is no .htaccess file in htdocs.
This can cause the problems you are having as well.

Just post for lots of help. :)

CSDsan
2-5-04, 08:16 PM
okey it was the chmod thing. Thanks for posting the ftp proggy. I was using WS_FTP 95, and its a little odd about changing the chmod. Theres no numbers like the 755 thing that I could find, its just a window that looks like this:

______Owner Group Other
View....| x..........x......x
Edit.....| x..........x.......x
Execute| x.........x.......x

x=Checkbox
.=empty space, just used here for a spacer.

Anyways, I used smartftp and the chmod was on 744. so i changed that to 755 and the site works again. I gotta reinstall my phpBB2 forum though. Fun. Fun. Fun. I hope I dont get any trouble from the mySQL database as a result of screwing around with it lastnight..
Anyways, Thanks a whole lot! And I must say, its really reassuring how friendly you people are :).

user9999
2-5-04, 08:48 PM
Just a little additional note
______Owner Group Other
View....| x..........x......x
Edit.....| x..........x.......x
Execute| x.........x.......x
=chmod 777
______Owner Group Other
View....| x..........x......x
Edit.....| x.......... .......
Execute| x.........x.......x
=chmod 755

Insure you dont chmod your /htdocs to 777