mysql?

[Nami]

Hi hi!

^^;; I'm sorry. I didn't know where to put this question and this seemed like a really good place.

*cough* I'm very new to all of this and I was wondering. What it mysql? How do you use it?

Also, for .jpg and .htmls in the cgi-bin the chmod should still be 644 right? *is confuzzled*

BTW, does anybody know phpnuke and be willing to tell me how it works? It looks really kewl, but I dunno how to use it. I thought *maybe* if I learned....

Thanks for looking at this stupid person's question. ^-^ I guess newbie's hafta start somewhere. And I wanna start! -_- And I'm sorry if this is bothering anyone.

~Nami-chan

[niv]

mySQL is a database server. it allows you to store information in databases (like in microsoft access).

HTML/JPG/GIF/PHP/any other non-CGI script files should be chmodded to either 644/744 or 655/755 unless you plan to write to them from a browser. in that case chmod it to 766 or 666. the CGI-BIN should be chmodded to 711.

[Nami]

Wow, thanks! ^-^;; I'll go check my files. I think some of my chmod's might have been wrong.

I know mysql is a database thingy, but how do you put in into your account? Well, I'm trying to put it in now, but I dunno how. Thanks. ^.^

~Nami-chan

[niv]

i think it would be better to check the documentation, i can't explain everything :o

http://www.mysql.com
http://www.perl.com
http://www.php.net

[Nami]

*sighz* I tried changing/double-checking my chmod's on my files, but it didn't work. I think I'll try e-mailing support to ask why.

0.o There's a 711 chmod? What are its checks? Wow. I didn't know that.

Thanks for the info. I looked at mysql and I'm guessing I had to download the mysql thing which I did...I'm also guessing that I hafta put in on my page to look/mess with it so thats what I'm doing now. ^^;; I hope I can figure out mysql. Thanks for the addys!

[niv]

711: rwx--x--x

prevents leeching via port 80.

[LastActionHero]

exactly which script are you trying to run? Give us some more details.

[Nami]

Well, if you are talking about the .cgi script I'm trying to run its here:

http://syste.ms/oekaki/

This is my oekaki that works (on a free server, but I want to move it):

http://odin.prohosting.com/nami001/cgi-bin/picture.cgi

And this is the one I'm trying to MAKE work:

http://www.mangacandy.com/cgi-bin/oekaki/picture.cgi

^^;; If that helps any. The sketch link won't work and the bg.jpg won't show up for some reason.

Ahhh!!! I still don't get how mysql works! Is it executable on your computer or do you have to put it on the internet? How do you execute it? Am I supposed to put it somewhere special?

~Nami-chan
:: one incredibly confused girl::

[niv]

mySQL is installed on the server, and you can call it using Perl DBI or PHP and you can send queries to it like you would when you run mysql -p from the telnet/ssh prompt. as for your script, did you have any other files that came with your BBS? did you write it to a file? if so, you have to upload those files to your server as well, and change the absolute path of the files in the script because it isn't the same.


(yes i am needcgispace :o)

[Nami]

Nyaaaa! XD Hayama-kun! What a kute name. I like it a lot!

Well, I'm trying to get the mysql thing created right now. I'm going to support and hopefully it will be created.

Any other files? Writing to a file? *blink* I'm confused.

Here: www.mangacandy.com/oekaki.zip

Thats my version of the oekaki. This is all the stuff I upload in my cgi-bin and chmod. Am I supposed to have other files than this?

[niv]

i dont think you have the data for the BBS. i'm confuzzled as much as you are. i'm a PHP guy.

[Nami]

I don't understand why this isn't working. ^^;; I dun think my hosting server knows either. At first we thought the perl path was wrong, but after we change it I still get the same results. *sighz* I must be dumb or something. i bet its something really simple.

BTW, Hayama-kun, after I have my "mysql database created" from my server....uh...how do I access it? *dun have the slightest clue what she's doing*

[niv]

it's better to have a professional explain it to you :p

there are plenty of books out there on mySQL, and they explain how you can access it via Perl (Perl DBI) or PHP.

http://www.php.net/manual/en/ref.mysql.php (mySQL functions) ;)

if you're using CPanel3, you can add mySQL databases and users, and "assign" users to those databases. note that all users can extract data from any of the databases, but in order to INSERT data, you must "assign" users to that database.

[meow]

Originally posted by Nami
Nyaaaa! XD Hayama-kun! What a kute name.
~":p"~

(not <G>-ing at you Nami. ;))

[Nami]

*looking through the php addy*

Kewl kewl, I think I understand. ^-^ So you make a .php file and when you execute it, its like you're using mysql. *gasp* I think I'm starting to get this!

I know what I put in login and password (duh, the log in and password created for me), but what do I put in for the "mysql_host" part?

*lol* Hi meow! ^-^

[niv]

well, the server you're on is your mySQL server, so your host is localhost, or if you want, you can put 127.0.0.1 as the host

[Nami]

Wow! ^------^ I'm messing with the php right now and this is really kewl! Thanks!

^^;; I can't do anything complicated yet, but this is really interesting to do. Thanks so much for your help. ^^ I'm prolly gonna get stuck somewhere soon and ask for help again, but right now I'm just trying out all these functions on the address you gave me. Hopefully I can stand a little on my own now...

>.< Now if only I could get my oekaki board to work.....*sigh*

~Nami-chan

:: XD One very happy girl ::

[Nami]

I was looking over the php/mysql functions at the php manuel, but I was wondering....

In order to instal phpnuke you have to make a database and put nuke.sql into it....how exactly do you do that w/ php? Or can you not and am I in big trouble? In the phpnuke install file it says:

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

So...uh...how do I do that? ^---------^ Thanks so much for looking at this stupid person's question.

~Nami-chan
:: dun kno what she's doing ::

[n15332]

to get the appropriate tables into your database for phpnuke, it is best if you go to www.phpmyadmin.net and get version 2.2.5 since that is what i use. I tried 2.2.6 but for some reason i just couldnt get it to work. with phpmyadmin you just browse to the sql file that came with phpnuke and all the tables are created instantly.